>>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;Thanks