我有一个使用stes访问ef4的查询,我在用户定义的排序方面遇到了问题。在调试过程中,我删除了动态排序,并对其进行了硬编码,但仍然存在这个问题。如果我交换/取消
var results = xxx
线在
GetMyBusinesses()
,我的结果没有任何不同的排序-它们总是按升序排序。
FYI
Name
是一个
varchar(200)
我的业务表上的SQL 2008中的字段。
private IQueryable<Business> GetMyBusinesses(MyDBContext CurrentContext)
{
var myBusinesses = from a in CurrentContext.A
join f in CurrentContext.F
on a.FID equals f.id
join b in CurrentContext.Businesses
on f.BID equals b.id
where a.PersonID == 52
select b;
var results = from r in myBusinesses
orderby "Name" ascending
select r;
//var results = from r in results
// orderby "Name" descending
// select r;
return results;
}
private PartialEntitiesList<Business> DoStuff()
{
var myBusinesses = GetMyBusinesses();
var myBusinessesCount = GetMyBusinesses().Count();
Results = new PartialEntitiesList<Business>(myBusinesses.Skip((PageNumber - 1)*PageSize).Take(PageSize).ToList())
{UnpartialTotalCount = myBusinessesCount};
return Results;
}
public classPartialEntitiesList<T> : List<T>
{
public PartialEntitiesList()
{
}
public PartialEntitiesList(int capacity) : base(capacity)
{
}
public PartialEntitiesList(IEnumerable<T> collection) : base(collection)
{
}
public int UnpartialTotalCount { get; set; }
}