linq转换,该如何处理

2013-10-21

linq转换select top 6 * from Article where ArticleState 1 order by ArticleID desc转成linq语句[解

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);

[解决办法]

引用:

引用:
C# code?1234 var res=(from q in Article where q.ArticleState<>1 orderby q.ArticleState descending select q).Take(6);
li……

和linq没有关系，那是C#语法。如果你用VB.NET，你就可以写<>了！