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

50 votes175 views3 answers
C# int array
C#
0 vote189 views1 answer
Sharepoint c# get list item query by lookup
C#
1 vote169 views1 answer
Check if network is available c#
C#
0 vote183 views1 answer
How to unfocus a richtextbox windows forms
C#
2 votes171 views2 answers
Validate data exist in database lara vel
C#
0 vote179 views1 answer
C# IEnumerable access element at index
C#
0 vote151 views1 answer
Search list for words c#
C#
0 vote206 views1 answer
Wpf richtextbox clear text
C#
2 votes173 views1 answer
Convert string int Linq
C#
3 votes207 views1 answer
How to convert angle to vector in c#
C#