entity framework 多个字段排序
如何对ef的某一个实体的多个属性进行排序?比如, order by c1 desc,c2,c3 desc --------------------编程问答-------------------- esql:SELECT VALUE it FROM NorthwindEntities.Customers as it order by it.c1 desc,it.c2,it.c3 desc
linq:
var cust = edm.Customers.OrderBy(c => c.CustomerID).OrderBy(c=>c.c2).OrderBy(c=>c.c3)
--------------------编程问答--------------------
我第一次用的就是你这个第二个,不行,排序不对 --------------------编程问答-------------------- ThenBy - 在 OrderBy 或 OrderByDescending 的基础上再正序排序
ThenByDescending - 在 OrderBy 或 OrderByDescending 的基础上再倒序排序 --------------------编程问答--------------------
thenby's right
thanx
--------------------编程问答-------------------- esql:
SELECT VALUE it FROM NorthwindEntities.Customers as it order by it.c1 desc,it.c2,it.c3 desc
linq:
var cust = edm.Customers.OrderByDescending(c => c.c3).OrderBy(c=>c.c2).OrderByDescending(c=>c.c1) ,因为在linq里面写的话顺序是反过来的
补充:.NET技术 , LINQ