I have this in sql:
select top(10) m.ManufacturerID,m.Name, COUNT(p.ProductID) as total from dbo.nop_manufacturer m
inner join dbo.Nop_Product_Manufacturer_Mapping p
on p.ManufacturerID = m.ManufacturerID
where m.Deleted!=1 and m.Published= 1
group by m.ManufacturerID, m.Name
order by total desc
Can anyone transform this to linq?
Thx!