>>I could use some help converting this to linq:
>>
>>

>>SELECT u.*
>>	FROM aspnet_Users u
>>	JOIN aspnet_UsersInRoles ur ON ur.UserId = u.UserId
>>	WHERE ur.RoleId = @RoleId
>>

>>
>>
>>I have this so far:
>>
>>

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

That was close. This works:

var users = from u in dc.aspnet_Users
            from ur in u.aspnet_UsersInRoles
            where ur.RoleId == RoleID 
            select u;

Thanks