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

2 votes179 views3 answers
Capitalize c#
C#
0 vote355 views1 answer
Unity how to set framrate C#
C#Unity
0 vote196 views1 answer
Tee into file
C#
0 vote184 views1 answer
Remove header visual studio android
C#
1 vote198 views2 answers
Huidige timestamp c#
C#
1 vote179 views1 answer
Asp.net validate web.config
C#
1 vote174 views1 answer
Make mesh follow wheel collider unity
C#
2 votes172 views1 answer
Draw sphere gizmo unity
C#
0 vote192 views1 answer
Redirect to another controller page in asp.net core
C#
1 vote187 views2 answers
Valid url in .net
C#