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 vote234 views1 answer
How to parse mongo db json in c#
C#
0 vote214 views1 answer
C# MemoryStream - Timeouts are not supported on this stream
C#
0 vote190 views3 answers
C# datagridview get selected row values
C#
13 votes208 views3 answers
C# list get last element
C#
-1 vote212 views2 answers
Error CS1513: } expected but there is already unity
C#
2 votes231 views1 answer
What is session management in asp.net
C#
-1 vote204 views2 answers
Rb.addforce c#
C#
4 votes210 views1 answer
Hyperx quadcast s uk
C#
0 vote186 views1 answer
Asp net img src path from database
C#
128 votes313 views6 answers
C# random number
C#