So in my LINQ code, rather than using an explicit Join to attach the Customer to the Orders table, I can query the Orders collection and retrieve the Customer information through the Orders navigation ...

Select c The C# code is slightly different, omitting the two uses of the Group keyword: var res = from c in nw.Customers join o in nw.Orders on c.CustomerID equals o.CustomerID into Ords where ...

Because I almost never write long linq queries in Linq to Objects without just converting to the pipeline-esque (or fluent if you prefer) style via extensions methods.