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

1 vote249 views1 answer
Wpf label text color rgb string
C#
46 votes305 views6 answers
Random in unity
C#
0 vote275 views1 answer
Coroutine after another
C#
0 vote285 views1 answer
How can I get my stripe customer ID?
C#
0 vote288 views1 answer
C# hardcode datetime quoting
C#
2 votes285 views1 answer
Pass parameter to thread c#
C#
18 votes301 views2 answers
Unity remove all child
C#Unity
0 vote272 views1 answer
Web.config customerrors not working
C#
0 vote271 views1 answer
Non null array length
C#
1 vote263 views1 answer
Make an object disappear from a c# script unity
C#