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

0 vote186 views1 answer
Unlit shader get the direction of camera UNity
C#
0 vote182 views1 answer
Phone
C#
35 votes194 views3 answers
Vb.net yes no cancel
C#
13 votes190 views2 answers
What is public static void
C#
20 votes288 views4 answers
How to change scenes in unity
C#Unity
4 votes423 views1 answer
How ot make a variable public without showing in the inspector
C#
1 vote253 views1 answer
2 rotation unity
C#Unity
11 votes200 views3 answers
C# get all enum values
C#
1 vote182 views1 answer
How to create a delegate in c#
C#
0 vote201 views1 answer
NewtonSoft get base64 string
C#