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()
}

0 تعليقات

إرسال تعليق

Post a Comment (0)

أحدث أقدم
NERV Open Source

Building production Spring Boot systems?

Explore NERV — open-source Java libraries for audit trails, persistence, exception handling, and reliable event-driven architecture.

Explore NERV on GitHub →