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 vote206 views2 answers
Unity screentoworldpoint
C#Unity
0 vote169 views1 answer
.net new template
C#
12 votes166 views2 answers
How to make an object move in unity
C#
0 vote169 views1 answer
Private Vector3 direction;
C#
0 vote191 views1 answer
How to invoke an AWS Lambda function asynchronously
C#
23 votes184 views3 answers
C# foreach on a dictionary
C#
14 votes165 views6 answers
C# convert list to string
C#
0 vote170 views1 answer
C# webbrowser upload file
C#
0 vote172 views1 answer
How to add multiple values in session in asp.net visual studio
C#
0 vote179 views1 answer
Aquarette
C#