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 vote265 views1 answer
How to create a random vector2 in unity
C#Unity
0 vote223 views1 answer
Unity blender shadow messed up
C#
0 vote227 views1 answer
C# sum object values
C#
0 vote275 views1 answer
CamelCase and snakeCase
C#
0 vote235 views1 answer
C# initialize constant
C#
2 votes231 views2 answers
Asp.net core url parameter
C#
0 vote250 views1 answer
C# count directories in directory and subdirectories
C#
-1 vote209 views1 answer
C# resize image from byte array
C#
0 vote247 views1 answer
Clickable table row asp.net core cursor
C#
5 votes230 views1 answer
Downlaod file and use C#
C#