Published on January 17, 2018
Link for all dot net and sql server video tutorial playlists
Link for slides, code samples and text version of the video
The following are the different types of joins in LINQ
Group Join – Discussed in Part 21
Inner Join – Discussed in Part 22
Left Outer Join – We will discuss in this video
Cross Join – Later Video
In this video we will discuss implementing LEFT OUTER JOIN in LINQ.
With INNER JOIN only the matching elements are included in the result set. Non-matching elements are excluded from the result set.
With LEFT OUTER JOIN all the matching elements + all the non matching elements from the left collection are included in the result set.