Top Manufacturers Order by product count

In the navigationmenu of manufacturers, i want to show only the top 10 manufacturers with the most products.

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!