>>>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 users = from u in dc.aspnet_Users > from ur in u.aspnet_UsersInRoles > where ur.RoleId == RoleID > select u; >>