we can implement left outer join in LINQ as well
suppose i have 2 tables
1. product
2. order.
In the order we have foreign key named as productId reference to product table
Now we want to achieve left or left outer join
var q=(from pd in dataContext.Products
join od in dataContext.Orders on pd.ProductID equals od.ProductID into t
from rt in t.DefaultIfEmpty()
select new {
pd.name,
….
}).ToList();
Thanks
🙂