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

You need to apply Distinct() to this one I think. Using Any() is better IMHO.
Cetin