How to apply LEFT JOIN in linq?

Accepted answer

Please check given below link for better understanding

https://docs.microsoft.com/en-us/dotnet/csharp/linq/perform-left-outer-joins

var q =
from c in categories
join p in products on c.Category equals p.Category into ps
from p in ps.DefaultIfEmpty()
select new { Category = c, ProductName = p == null ? "(No products)" : p.ProductName };

+1

Thanks Puneet.

and also thanks to madan and sanwar.

0

Hello Yogendra

Check these Videos

https://www.youtube.com/watch?v=Te2o5qakvZk

Or check these

https://codingsense.wordpress.com/2009/03/08/left-join-right-join-using-linq/

https://stackoverflow.com/questions/3404975/left-outer-join-in-linq

https://docs.microsoft.com/en-us/dotnet/csharp/linq/perform-left-outer-joins

+1