Silverlight 4 中使用 WCF RIA 的服务器端动态排序和分页

发布于 2024-12-12 01:13:14 字数 797 浏览 0 评论 0原文

由于数据量巨大，我们的 SL4 应用程序遇到速度变慢的问题。为了解决这个问题，我们决定在服务器端进行分页和排序。

数据库结构：

客户表是（customerID，CustomerLabel，personId）
人员表是（personId，FirstName）
Datagrid有（CustomerLabel，FirstName）

服务器端的分页一切正常，在尝试排序时，我可以轻松排序“CustomerLabel”使用：

IEnumerable<Customer> source = this.ObjectContext.Customers.Include("Person"); 

 source = source.OrderByDescending<Customer, object>(p => GetKeySelector(p, propertyName));

private static object GetKeySelector(Customer p, string propertyName)
{
    PropertyInfo propertyInfo = target.GetType().GetProperty(propertyName);
    return propertyInfo.GetValue(target, null);
}

问题： 而数据网格中的 propertyName 是“Person.FirstName”。 “propertyInfo”为空。

我希望有人能在这方面帮助我。

原文

Due to huge volume of data, our SL4 application encounter problem by getting slower. To solve that we decide to do paging and sorting serverside.

Database structure:

Customer table is(customerID, CustomerLabel, personId)
Person table is(personId, FirstName)
Datagrid has (CustomerLabel, FirstName)

The paging at server side went all ok, while trying for sorting, I can sort easily for "CustomerLabel" using:

IEnumerable<Customer> source = this.ObjectContext.Customers.Include("Person"); 

 source = source.OrderByDescending<Customer, object>(p => GetKeySelector(p, propertyName));

private static object GetKeySelector(Customer p, string propertyName)
{
    PropertyInfo propertyInfo = target.GetType().GetProperty(propertyName);
    return propertyInfo.GetValue(target, null);
}

Problem:
while propertyName is "Person.FirstName" in datagrid. The "propertyInfo " is null.

I wish if someone could help me on this.

分享到QQ

分享到微博