>>SELECT u.* >> FROM aspnet_Users u >> JOIN aspnet_UsersInRoles ur ON ur.UserId = u.UserId >> WHERE ur.RoleId = @RoleId >>>>
>>var user = from u in dc.aspnet_Users >> where u. >> select u; >>>
>var query = from u in dc.aspnet_users where u.aspnet_UsersInRoles.RoleId = RoleId select u; > >User usr = query.FirstOrDefault(); > >>
var query = from ur in dc.aspnet_UsersInRoles where ur.RoleId = RoleId select ur.aspnet_User; // assuming in Model navigation from Roles to Users is renamed to be singular var users = query.Distinct();Cetin