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 vote360 views3 answers
Student roll mvc
C#
-3 votes309 views1 answer
How to split a string by in c#
C#
0 vote366 views1 answer
How to make dobuble jump unity 2d
C#Unity
0 vote394 views1 answer
Audio source pause unity
C#Unity
3 votes344 views1 answer
Unity editor select object in script
C#
0 vote319 views1 answer
Get width of image unity
C#
1 vote415 views1 answer
Unity image
C#Unity
0 vote320 views1 answer
Largest prime factor of a number
C#
0 vote312 views1 answer
C# register write value
C#
2 votes328 views1 answer
Unity public static variable
C#