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 vote236 views1 answer
Prevent C# app from lingering after closing in background processes
C#
0 vote241 views1 answer
ENUM error codes all
C#
0 vote223 views1 answer
C# get out of for loop
C#
0 vote224 views1 answer
Ignore warning openxml
C#
0 vote248 views1 answer
C# datetime.now to string only numbers
C#
0 vote242 views2 answers
Show title combox check box wpf
C#
0 vote224 views1 answer
C# convert enumb to int array
C#
33 votes219 views2 answers
How to instantiate a gameobject
C#
5 votes189 views1 answer
C# remove last item from list
C#
0 vote211 views1 answer
C# get the return value of a func
C#