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 vote322 views1 answer
Asp.net c# set session timeout
C#
0 vote348 views1 answer
Excel isrlgood
C#
31 votes308 views3 answers
Create new gameobject unity
C#
6 votes320 views2 answers
How to disable and enable rigidbody unity
C#
0 vote326 views1 answer
Internal static object ds
C#
0 vote357 views1 answer
C# Convert 1 range to another
C#
1 vote300 views1 answer
CurrentTimeMillis c#
C#
2 votes319 views1 answer
Unity 2d detect click on sprite
C#
0 vote316 views1 answer
Loop menustrip buttons
C#
0 vote314 views1 answer
System.drawing.color to system.consolecolor
C#