Welcome to Software Development on Codidact!
Will you help us build our independent community of developers helping developers? We're small and trying to grow. We welcome questions about all aspects of software development, from design to code to QA and more. Got questions? Got answers? Got code you'd like someone to review? Please join us.
Post History
I am interested in performing a LEFT JOIN using LINQ-2-SQL when working with method call notation. This answer suggests a way that relies on GroupJoin but it is more verbose than expected: var le...
#2: Post edited
by
Alexei
·
2020-11-11T13:48:42Z (about 4 years ago)
simplified the query
#1: Initial revision
by
Alexei
·
2020-11-11T13:44:14Z (about 4 years ago)
How to perform LEFT JOIN using LINQ method call notation?
I am interested in performing a LEFT JOIN using LINQ-2-SQL when working with method call notation.
This [answer](https://stackoverflow.com/a/3792904/2780791) suggests a way that relies on GroupJoin but it is more verbose than expected:
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 }));
Is there any other way to perform this?