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

21 votes337 views2 answers
Unity set object scale
C#Unity
0 vote326 views1 answer
Lock a cache in asp.net
C#
21 votes302 views4 answers
C# create array
C#
0 vote286 views2 answers
Openiddect ef core table not creating
C#
0 vote281 views1 answer
Jq map over array
C#
1 vote337 views1 answer
Xamarin forms open new page on button click
C#
0 vote308 views1 answer
Unity only one component type
C#
2 votes353 views2 answers
How to deactivate objects through scripts in unity
C#Unity
0 vote320 views1 answer
If this is a Windows (R) Communication Foundation service to which you have access, please check that you have enabled metadata publishing at the specified address.
C#
24 votes303 views3 answers
C# class to byte array
C#