Converting simple Sql query to Linq

Question

Im working on my school project and im new in writing LINQ query's so its hard for me to convert this SQL query to LINQ. I have problem with writing linq query for top 10 best selling products. I have table for Products and table for Selling item.

My SQL query works good.

I tried with this:

  List<Proizvodi> proizvodi = db.Proizvodi.
            OrderByDescending(x => db.IzlazStavke.Where(y => y.ProizvodID == x.ProizvodID).
            Sum(t => t.Cijena)).Take(10).ToList();

But result is not good, any help please.

I got 10 products in list but not top 10 best selling products. — TariqN
– TariqN, Commented Jun 5, 2016 at 20:59
Why are you so surprised? In SQL query you get a sum of IzlazStavke.Kolicina and in Linq query you get Proizvodi.Cijena. — Maciej Los
– Maciej Los, Commented Jun 5, 2016 at 21:03

Maciej Los · Accepted Answer · 2016-06-05 21:13:24Z

1

I'll try something like this:

List<Proizvodi> proizvodi = db.Proizvodi
        .OrderByDescending(x => db.IzlazStavke
             .Where(y => y.ProizvodID == x.ProizvodID)
             .GroupBy(a=>a.ProizvodID)
             .Select(grp=>grp.Sum(z=>z.Kolicina))
        .Take(10)
        .ToList();

answered Jun 5, 2016 at 21:13

Maciej Los

8,6311 gold badge22 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Converting simple Sql query to Linq

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related