cl z

cl z

  • NA
  • 3
  • 450

Convert a sql query into Linq

Jul 6 2020 3:53 AM
 Can anyone help me with this query convert?
 
select rl.Id, rl.IdTestataListino, rl.IdProdotto, rl.Prezzo, pr.Descrizione, count(*) as N_Ordini
from RigaListino as rl
left join RigaOrdine as ord
on rl.IdProdotto = ord.IdProdotto
left join Prodotto as pr
on pr.Id = rl.IdProdotto
where rl.IdTestataListino = 2
group by rl.Id, rl.IdTestataListino, rl.IdProdotto, rl.Prezzo, pr.Descrizione
order by N_Ordini

Answers (2)