Breaking News: Grepper is joining You.com. Read the official announcement!

c# iqueryable left join

Watcher O_O answered on September 1, 2022 Popularity 3/10 Helpfulness 1/10

answer c# iqueryable left join

c# iqueryable left join

Comment

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 })
                   .SelectMany(z => z.ms.DefaultIfEmpty(), (n, m) => new { n = n, m ));

Popularity 3/10 Helpfulness 1/10 Language csharp

Source: stackoverflow.com

Tags: c# iqueryable left-join

Link to this answer
Share Copy Link