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

0 vote129 views1 answer
Asp.net web forms
C#
0 vote120 views1 answer
How to center a window in monogame
C#
0 vote120 views1 answer
Client = matrice[indexselectedclient] as String[];
C#
10 votes178 views3 answers
Unity C# instantiate prefab
C#Unity
0 vote89 views1 answer
C# json contains property
C#
0 vote129 views1 answer
Yes no confirmation modal javascript
C#
0 vote148 views1 answer
New texture unity
C#
0 vote129 views2 answers
FiveM pc key code
C#
0 vote121 views1 answer
How to make a destroy reference in unity
C#
20 votes129 views6 answers
Random number generator
C#