8,497
社区成员
发帖
与我相关
我的任务
分享
var result=(from p in product
orderby p.LastUpdateTime descending
join u in users on p.UserName=u.UserName
select new{
UserName=p.UserName,
Name=p.Name,
LastUpdate=p.LastUpdateTime,
AuthorLevel=u.AuthorLevel }).Take(3).OrderBy(s=>s.AuthorLevel);
var query = from p in product
orderby p.LastUpdateTime
group p by p.UserId into g
from s in g.Take(3)
join u in users
on s.UserId equals u.UserId
orderby s.UserId
select new { s, u };
var query = from p in product
join u in users
on p.UserId equals u.UserId
orderby p.LastUpdateTime
group new { p, u } by u.UserId into g
from s in g.Take(3)
orderby s.p.UserId
select new { s.p, s.u };