>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