对多关系，使用linq 根据一个已知的对象 查询与之关联的对象，linq 怎么写？

Question

比如 上图 是 asp.net identity 用户 和用户角色 关系 ，我想根据用户查询得到该用户对应的角色列表。用linq 来查询， 请问大家怎么写ｌｉｎｑ　查询。

Answer 1

var uur = from AspNetUser in AspNetUsers
join AspNetUserRole in AspNetUserRoles
on AspNetUser.Id equals AspNetUserRole.UserId into AspNetUsers_Roles
join AspNetRole in AspNetRoles
on AspNetUsers_Roles.RoleId equals AspNetRoles.Id into AspNetUeserRole
select new
{
User = AspNetUsers_Roles.UserId,
RoleId = AspNetUeserRole.RoleId,
Name =AspNetUeserRole.Name
Email = AspNetUsers_Roles.Email,
EmailConfirmed = AspNetUsers_Roles.EmailConfirmed，
...(其他字段)
};