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 missi...
https://www.czetsuyatech.com/2011/12/c-linq-query-on-bridge-table.html
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() }
Post a Comment