public static List <Role> GetGrantRolesForUser(Guid userid) { List <Role> roles = new List <Role>(); xRPDataContext dataContext = new xRPDataContext(); var result = dataContext.Sp_Qlht_GetAllGrantRolesForUser(userid); foreach (Sp_Qlht_GetAllGrantRolesForUserResult r in result) { roles.Add(new Role { ID = r.RoleId, Name = r.RoleName, IsGrant = true }); } return(roles); }