var data = DbContext.Where(a => a.CustomerID == CustomerID).
OrderByDescending(a => a.IsSelf).ThenByDescending(a => a.CreateTime).
Select(a => new
{
id = a.Id,
name = a.Name,
createTime = a.CreateTime
}).ToList().
Select((a,Index) =>new {
RowsNum = Index,
id = a.Id,
name = a.Name,
createTime = a.CreateTime
}).ToList()
注意:在数据还没执行查询的时候是不能这样玩的,也就是说在IQueryable的时候是不能这样玩,查询之后的IEnumerable的情况下,代码中ToList后才行