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 vote198 views1 answer
How to print a word in C#
C#
2 votes234 views2 answers
Unity don't destroy on load
C#Unity
2 votes221 views2 answers
How to filter a list in c#
C#
18 votes223 views1 answer
How to remove a component from an object in unity
C#Unity
0 vote223 views1 answer
Input field to float unity
C#
0 vote219 views1 answer
Wpf app how to get all elements which are exposed to script
C#
0 vote240 views1 answer
C# program lambda Func
C#
12 votes221 views1 answer
.sh script: check if file exist
C#
0 vote206 views1 answer
C# xml comment type reference
C#
3 votes225 views3 answers
Byte array to base64 c#
C#