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 vote261 views1 answer
Unity stopwatch timer
C#Unity
36 votes513 views5 answers
Unity key pressed
C#Unity
0 vote168 views1 answer
C# azure get vm get cpu usage
C#
0 vote184 views1 answer
Unity inspector draw line
C#
5 votes214 views1 answer
F#
C#
0 vote183 views1 answer
How to trigger event when a com device is connected in c#
C#
2 votes242 views1 answer
C# insert into database
C#
0 vote179 views1 answer
Dictionary all key where value c#
C#
0 vote193 views3 answers
Switch c#
C#
0 vote139 views1 answer
Controller class
C#