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 vote284 views1 answer
How to detach the camera from the player after death unity
C#Unity
1 vote178 views1 answer
Remove index from array c#
C#
0 vote155 views1 answer
C# picturebox transparente
C#
3 votes164 views2 answers
C# bytes to image
C#
17 votes212 views3 answers
Unity get list of children
C#Unity
1 vote222 views1 answer
Unity add addressables
C#Unity
0 vote171 views1 answer
Card caption
C#
5 votes165 views2 answers
C# find one object in list where
C#
1 vote157 views1 answer
Httppostedfilebase in .net core 3.1
C#
0 vote159 views1 answer
C# reflection create generic type
C#