How can I GROUP a LINQ query that includes multiple joined tables with ambiguous column names?

Asked Nov 04 '20 at 14:22

Active Nov 04 '20 at 14:22

Viewed 37 times

Here is my SQL-Query that I want to convert to LINQ:

SELECT artikel.id, charge.id
from Lots charge
JOIN Product artikel on charge.artikel = artikel.id
JOIN StorageQuantity_TAB lmengeTAB on charge.id = lmengeTAB.charge
JOIN StorageQuantity lmenge on lmengeTAB.id = lmenge.id
GROUP BY artikel.id, charge.id

That´s what I got so far:

var query = (from charge in Lots
            join artikel in PartProducts on charge.Artikel equals artikel.Id
            join lmengeTAB in StorageQuantity_TABs on charge.Id equals lmengeTAB.Charge
            join lmenge in StorageQuantities on lmengeTAB.Id equals lmenge.Id
                select new
                {
                    artikel.Id,
                    chargeID = charge.Id,
                }).ToList();

So how do I include that GROUP BY statement?

asked Nov 04 '20 at 14:22

manu

Use query variable and do a groupby – Tarik Nov 04 '20 at 14:24
1

What's wrong with `SELECT DISTINCT`? – jarlh Nov 04 '20 at 14:28
1

(..).Distinct(); – Serg Nov 04 '20 at 14:31
Thanks guys, never heard of the Distinct() Method before! – manu Nov 04 '20 at 15:05
You might find my [SQL to LINQ Recipe](https://stackoverflow.com/questions/49245160/sql-to-linq-with-multiple-join-count-and-left-join/49245786#49245786) helpful. – NetMage Nov 04 '20 at 22:36

How can I GROUP a LINQ query that includes multiple joined tables with ambiguous column names?

0 Answers0