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;