Add new keyword "leftjoin" to make LINQ more readable

[asydneylover]

LINQ is amazing, but only if I don't need to do left / right outer join, the solution to use the DefaultIfEmpty() method looks weird.
I wish if C# could extend it keywords to add "leftjoin", "rightjoin" so that I can simply code as following:

var q = from c in db.Categories
            leftjoin p in db.Products on c.CategoryID equals p.CategoryID
            select new 
            {
                     p.ProductName, 
                     c.CategoryName
            }

[svick]

This is a duplicate of #361.

[lachbaer]

@jnm2 I'm using ```cs instead of ```c#. Easier to type with one hand ;-)

[gafter]

Per @svick this is a duplicate of #361.

[StevenRasmussen]

Anyone wanting this MUST go to #361 and click both the up arrow and thumbs up just below the last item for your vote to be counted:

Yes... it looks like you're voting for the comment... which is against the idea... but you're actually voting for the idea. You can read the discussion around that in the comments.