有張帖子表和回復表，
帖子串列以帖子下最新的回復來排序。
這樣 linq 要怎么寫呢？
帖子和回復的表是一堆多
uj5u.com熱心網友回復：
沉下去了？·················uj5u.com熱心網友回復：
。。。大概這樣。from a in 帖子
join b in 回復 on a.帖子id=b.帖子id
orderby b.createTime descending
select b;
uj5u.com熱心網友回復：
這樣的話就會查出多條一樣的帖子了
uj5u.com熱心網友回復：
加上你要查的帖子idfrom a in 帖子
join b in 回復 on a.帖子id=b.帖子id
where a.帖子id='你要查詢的帖子id'
orderby b.createTime descending
select b;
uj5u.com熱心網友回復：
加帖子ID？ 我是要渲染出來一個串列啊 ，你加個 where 進去意義是啥
uj5u.com熱心網友回復：
最后destinct一下去重就好了。
uj5u.com熱心網友回復：
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();
轉載請註明出處，本文鏈接：https://www.uj5u.com/net/34598.html
標籤：ASP.NET