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 vote143 views1 answer
C# convert enumb to int array
C#
4 votes158 views2 answers
C# readline char
C#
0 vote142 views1 answer
C# alphabetize a list of string
C#
0 vote137 views1 answer
Unity disable the display of the camera frustrum
C#
1 vote137 views1 answer
C# size of enum
C#
0 vote153 views1 answer
Player not following slide object unity 2d
C#
0 vote142 views1 answer
On collision enter by layer 2d unity
C#
1 vote140 views1 answer
Unity main texture not working
C#
0 vote143 views1 answer
40/100 percentage
C#
1 vote163 views1 answer
C# add two int variables
C#