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 vote131 views1 answer
Unity c# store gameobject in array
C#Unity
50 votes119 views4 answers
Unity how to load a scene
C#
0 vote109 views2 answers
Answer
C#
0 vote112 views1 answer
Min max to 01
C#
22 votes106 views5 answers
C# list of strings
C#
-1 vote84 views1 answer
Run as administrator vs 2019
C#
5 votes120 views1 answer
C# make request to rest api
C#
0 vote124 views1 answer
Create entity c# d365
C#
-1 vote123 views1 answer
Access audio source from gameobject unity
C#
14 votes120 views2 answers
How to move player with transform. position
C#