>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; >How about something like this...
var query = from u in dc.aspnet_users where u.aspnet_UsersInRoles.RoleId = RoleId select u; User usr = query.FirstOrDefault();Kurt