C# linq extension methods left join

var leftJoin = p.Person.Where(n => n.FirstName.Contains("a"))
                       .GroupJoin(p.PersonInfo, 
                                  n => n.PersonId,
                                  m => m.PersonId,
                                  (n, ms) => new { n, ms = ms.DefaultIfEmpty() })
                       .SelectMany(z => z.ms.Select(m => new { n = z.n, m }));

Source: stackoverflow.com

Similar codes

3 votes186 views1 answer
C# find item in list
C#
0 vote165 views1 answer
Linq query to fetch parent child data from same table in c#
C#
0 vote197 views1 answer
Unity set parent canvas
C#Unity
0 vote172 views1 answer
C# enum key value
C#
0 vote168 views1 answer
HOW TO RETURN CELL VALUE FROM EXCEL IN C#
C#
10 votes168 views6 answers
String to enum c#
C#
-2 votes203 views1 answer
Unity c# flip sprite
C#Unity
7 votes210 views1 answer
How to detect a mouse click in unity
C#Unity
0 vote201 views1 answer
Interop C# save as and replace
C#
47 votes178 views5 answers
Read file c#
C#