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 vote181 views1 answer
How to turn off sprite renderer in unity
C#
3 votes247 views1 answer
Check object is in layermask unity
C#Unity
0 vote230 views1 answer
EF will not create columns RULE
C#
0 vote232 views1 answer
Map Range Clamped unity
C#Unity
16 votes179 views5 answers
Append an array in c#
C#
0 vote181 views1 answer
Instantiate an object at a certain position unity
C#
0 vote177 views1 answer
Google mobile ads app id
C#
3 votes252 views1 answer
Unity detect any key
C#Unity
41 votes184 views6 answers
Prime Numbers
C#
17 votes189 views4 answers
Dictionary c#
C#