public static Role GetRole(string name) { CTSContext entities = new CTSContext(); return entities.Roles.Where(p => p.Name == name).SingleOrDefault(); ; }