Executing a linq query with a bridge table like aspnet_Users and aspnet_Roles

Using model first approach, we add aspnet_Users, aspnet_Roles and aspnet_UsersInRoles in the edmx file. But why is aspnet_UsersInRoles missing? It's because aspnet_Users has one-to-many relationship to aspnet_Roles. To get the role of the user, we need to execute the linq statement below.
class Person {
  public string UserName { get; set; }
  public string RoleName { get; set;
}

from a in _a2REntities.aspnet_Users
select new Person {
  Name = a.Username,
  RoleName = a.aspnet_Roles.Select(p=>p.RoleName).FirstOrDefault()
}
Executing a linq query with a bridge table like aspnet_Users and aspnet_Roles Executing a linq query with a bridge table like aspnet_Users and aspnet_Roles Reviewed by Edward Legaspi on Tuesday, December 20, 2011 Rating: 5

No comments:

Powered by Blogger.