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 vote255 views1 answer
Mvc get base url
C#
0 vote262 views1 answer
Hacking
C#
1 vote262 views2 answers
How convert the string time stamp to date in laravel
C#
0 vote282 views1 answer
Thread.Sleep() without freezing the UI
C#
0 vote237 views3 answers
C# code examples
C#
13 votes288 views3 answers
Java.sql.sqlexception: access denied for user 'root'@'localhost' (using password: no)
C#
0 vote284 views1 answer
Unity generate random offset position around a gameobject
C#Unity
2 votes270 views1 answer
Join array elements
C#
0 vote321 views1 answer
Hashing a file in C#
C#
0 vote322 views1 answer
Regex path pattern
C#