entity framework 多个字段排序

[uxspy]

如何对ef的某一个实体的多个属性进行排序？比如, order by c1 desc,c2,c3 desc

[uxspy]

[Quote=引用 1 楼 xray2005 的回复:]
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)

[/Quote]

我第一次用的就是你这个第二个，不行，排序不对

[uxspy]

[Quote=引用 3 楼 jarod 的回复:]
ThenBy - 在 OrderBy 或 OrderByDescending 的基础上再正序排序

ThenByDescending - 在 OrderBy 或 OrderByDescending 的基础上再倒序排序
[/Quote]

thenby's right

thanx

[cjc1983]

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里面写的话顺序是反过来的

[Jarod]

ThenBy - 在 OrderBy 或 OrderByDescending 的基础上再正序排序

ThenByDescending - 在 OrderBy 或 OrderByDescending 的基础上再倒序排序

[xray2005]

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)