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

10 votes137 views3 answers
How to lock and hide a cursor unity
C#
28 votes153 views6 answers
String length c#
C#
0 vote213 views1 answer
ElevatedButton change color
C#
29 votes199 views4 answers
Unity key detection
C#Unity
4 votes156 views1 answer
Unity new vector3
C#
1 vote169 views1 answer
Move file c#
C#
0 vote130 views1 answer
C# program that print charater from A to Z and it's corresponding number
C#
15 votes139 views10 answers
Hello world
C#
0 vote158 views2 answers
How to get src value from img tag in c#
C#
1 vote142 views3 answers
Remove comma from string c#
C#