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

2 votes143 views1 answer
Unity c# throw exception
C#
0 vote136 views1 answer
Hahhaa i hack u
C#
6 votes134 views1 answer
Get last element of array c#
C#
-1 vote136 views1 answer
How to backgrund c# red
C#
0 vote160 views1 answer
Uninitialized array c#
C#
0 vote155 views1 answer
Unity 2d swap out background image
C#Unity
1 vote177 views1 answer
Make mesh follow wheel collider unity
C#Unity
0 vote130 views1 answer
Custom Encrypted String Type
C#
1 vote143 views1 answer
Uuid generator asp.net
C#
0 vote131 views1 answer
Wpf binding object get value
C#