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

14 votes238 views6 answers
C# convert list to string
C#
0 vote267 views2 answers
Can a dictionary type use get set c#
C#
1 vote224 views1 answer
Wpf data context
C#
19 votes258 views2 answers
Unity reset scene
C#
3 votes239 views1 answer
Split on uppercase c#
C#
0 vote297 views1 answer
Unity get max occurrence in list
C#Unity
1 vote239 views1 answer
C# générer un nombre aléatoire
C#
0 vote270 views1 answer
Convert object to xml c# example code
C#
0 vote250 views1 answer
C# print expression tree
C#
3 votes253 views3 answers
How to move mouse with c#
C#