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 vote319 views1 answer
C# ignore enter key
C#
0 vote312 views2 answers
How to find the text position in excel in c#
C#
1 vote315 views1 answer
C# multiple inheritance
C#
2 votes375 views3 answers
Constructor definition
C#
0 vote347 views3 answers
Www.elking.net
C#
1 vote373 views1 answer
How to turn off sprite renderer in unity
C#Unity
12 votes354 views3 answers
Git checkout reset hard
C#
0 vote335 views1 answer
.net core copy directory to output
C#
1 vote343 views1 answer
Take screenshot in c#
C#
0 vote334 views1 answer
C# object to dictionary
C#