Extend the LINQ to support LEFT JOIN or GROUP BY in a more SQL-like way

Topics: C# Language Design
Oct 13, 2014 at 3:39 PM
Can we extend LINQ to have a keyword "leftjoin" or "rightjoin" in C# so that I can do LEFT JOIN in C# in a more natural, SQL-like way instead of using DefaultIfEmpty() ?

For example I can write in C#:
var x = from u in db.Users leftjoin o in db.Orders on o.UserID = u.UserID select new {u.Name, o.OrderNumber}