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

10 votes139 views2 answers
Forech unity
C#
26 votes151 views10 answers
For loop
C#
0 vote131 views1 answer
Collection to datatable c#
C#
0 vote136 views1 answer
Firefoxoptions setpreference to trust certificates
C#
0 vote138 views1 answer
C# blazor in .net framework
C#
0 vote153 views1 answer
Uri file path c#
C#
1 vote161 views1 answer
Unity mouse click position
C#Unity
0 vote133 views1 answer
Scale between tow ranges c#
C#
6 votes133 views2 answers
Readonly vs const c#
C#
0 vote143 views1 answer
Asp.net mvc class="" inline select
C#