求一个linq Row_number的写法
linq怎么实现下面的sql,就是选出公众号表(spiderapps)的公众号名称及对应的文章表(spiderarticles)中阅读数最高的文章

select app.appname,art.*
from spiderapps app
left join (select content_url,title,read_num,biz,ROW_NUMBER() over(partition by biz order by read_num desc)rn from spiderarticles )art on art.biz=app.biz and art.rn=1
order by read_num desc

...全文


