62,074
社区成员
发帖
与我相关
我的任务
分享
var result = (from a in entities.Article
orderby
(from c in entities.Comment
where c.ArticleId == a.ID
select new
{
c.PubDate
}).Max(p => p.PubDate) descending
select new
{
a.ID,
a.Title,
a.Content,
a.PubDate,
LatestCommentDate =
(from c in entities.Comment
where c.ArticleId == a.ID
select new
{
c.PubDate
}).Max(p => p.PubDate)
}).ToList();
from a in 帖子
join b in 回复 on a.帖子id=b.帖子id
orderby b.createTime descending
select b;