使用linq进行分组和排序

Rents 和 People

我是linq语句编程的新手。下面是我要转换为linq的sql查询:

select top 20 r.partnerid, max(p.PartnerName )
from Rents r join People p on p.Partnerid = r.Partnerid
where r.partnerid > 0 
group by  r.partnerid
order by  count(r.rentid) desc

var linqQuery = from r in meta.Rents 
             join p in meta.People on r.PartnerId equals p.PartnerId
             where r.PartnerId > 0 
             group r by r.PartnerId into pp
             select new
             {
                 PartnerId = pp.Key,
                 PartnerName = ??? //  PartnerName is a field/column from People
             } 
             // order by ?