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 vote223 views2 answers
C# array.reduce
C#
3 votes225 views4 answers
Alert message in c# windows application
C#
1 vote243 views2 answers
Unity 2d looka tt mouse
C#Unity
0 vote270 views1 answer
Ef core add OnModelCreating foreign key
C#
0 vote240 views1 answer
C# dapper execute stored procedure with parameters
C#
1 vote218 views1 answer
C# how to refresh your binding source
C#
1 vote247 views2 answers
Restart level unity
C#Unity
23 votes236 views3 answers
C# foreach on a dictionary
C#
2 votes203 views1 answer
Snx disconnect linux
C#
0 vote213 views1 answer
Coda2
C#