How can two left joins from a single table on similar fields be translated into LINQ when more than two tables are involved?

Question

This is the query:

SELECT colA, colB, colC
FROM TableA 
LEFT JOIN TableB 
ON TableA.colA = tablea.colA
LEFT JOIN TableC 
ON TableA.colA = TableC.colA

This is my LINQ code:

from a in TableA
join b in TableB on a.colA equals b.colA 
join c in TableC on a.colA equals c.colA 
select new { values here}

but it doesn't seem to work.

Here is the exact schema we will be using

Does this answer your question? [LEFT OUTER JOIN in LINQ](https://stackoverflow.com/questions/3404975/left-outer-join-in-linq) — Mark Benningfield, Aug 21 '21 at 15:03
[Don’t use Linq’s Join. Navigate!](https://coding.abel.nu/2012/06/dont-use-linqs-join-navigate/) — Gert Arnold, Aug 21 '21 at 15:52

score 0 · Accepted Answer · answered Aug 21 '21 at 15:06

0

try this

data= (from a in TableA
join b in TableB on a.colA equals b.colA into bj
 from b in bj.DefaultIfEmpty()
join c in TableC on a.colA equals c.colA  into cj
 from c in cj.DefaultIfEmpty()
select new { a.Cola,b.Colb, c.Colc}).ToList();

answered Aug 21 '21 at 15:06

Serge

40,935
4
18
45

How can two left joins from a single table on similar fields be translated into LINQ when more than two tables are involved?

1 Answers1