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

6 votes124 views1 answer
Unity rotate vector
C#
0 vote124 views1 answer
How to chceck for a tag in a trigger enter 2d unity
C#
0 vote131 views1 answer
How to solve error in ExecuteNonQuery() in asp.net
C#
2 votes126 views1 answer
Change image source wpf
C#
-1 vote132 views1 answer
Task w = Task.Delay(600);w.Wait();new Program().Start();
C#
1 vote159 views2 answers
Unity for loop array
C#Unity
4 votes114 views1 answer
How to get the current gameobject animator in unity
C#
1 vote115 views1 answer
Remove end character of string c#
C#
1 vote121 views1 answer
Unity character controller ignore collision
C#
1 vote143 views1 answer
C# copy an object
C#