Document how to generate a left join

[ajcvickers]

No description provided.

[bricelam]

from c in db.Customers
join o in db.Orders on c.Id equals o.CustomerId into orders
from o in orders.DefaultIfEmpty()
select new { c, o }

SELECT c.*, o.*
FROM Customers AS c
LEFT JOIN Orders AS o ON c.Id = o.CustomerId