linq2sql and multiple joins

Question

is it possible to do multiple joins:

from g in dataContext.Groups
join ug in dataContext.UsersGroups on g.Id equals ug.GroupId
join u in dataContext.Users on u.
where ug.UserId == user.Id
select GroupRepository.ToEntity(g);

in the sample above all is fine until i press "." in the end of the 3rd line. there i expect to get intellisense and write u.Id == ug.UserId but it doesn't appear. and of course this code doesn't compile after.

what did i wrong?

ANSWER: the order of aliases is important. so i've used ug.UserId equals u.Id

Answer 1

The following code works for me in LINQ to SQL (Northwind database)

 var dataContext = new NorthwindDataContext();
 var x = from c in dataContext.Customers
       join o in dataContext.Orders on c.CustomerID equals o.CustomerID
       join od in dataContext.Order_Details on o.OrderID equals od.OrderID
       select c;