How do I do a left outer join in LINQ?

Question

Can anybody explain in detail how to implement a left outer join in LINQ?

Answer 1

The key aspect here is DefaultIfEmpty()

Take a look at the following article to get a basic understanding. The example here is demonstrated for LINQ to SQL.

http://smehrozalam.wordpress.com/2009/06/10/c-left-outer-joins-with-linq/

If you are looking for LINQ to Objects example, then have a look at this

http://www.hookedonlinq.com/OuterJoinSample.ashx