linq转换
select top 6 * from Article where ArticleState <> 1 order by ArticleID desc
转成linq语句
[解决办法]
先orderby 在 take 取前6条
[解决办法]
var list=Article .Where(t=>t.ArticleState !=1).OrderByDescing(t=>t.ArticleID).Take(6).ToList();
[解决办法]
var res=(from q in Article
where q.ArticleState<>1
orderby q.ArticleState descending
select q).Take(6);