About sorting and paging

[Max]

As others I had to sort before the RadDataPager paging takes action so I solved like this:

• I created the MyNorthwindContext like in the documentation
• Then I added a property with my sort, something like

  public class MyNorthwindContext : NorthwindEntities
  {
      public MyNorthwindContext() : base(new Uri("http://services.odata.org/Northwind/Northwind.svc", UriKind.Absolute)){}
  
      public DataServiceQuery<Category> SortedCategories
      {
          get
          {
              if ((this._SortedCategories == null))
              {
                  this._SortedCategories = base.CreateQuery<Category>("Categories")
                      .AddQueryOption("$orderby", "CategoryID desc");
              }
              return this._SortedCategories;
          }
      }
      private DataServiceQuery<Category> _SortedCategories;
  }

• so
  
  

  <telerik:RadDataServiceDataSource Name="categoriesDataSource" QueryName="SortedCategories" AutoLoad="True">

Is that ok?

[Max]

No, it is not.
RadGridView sorting will cause exception.

So, in a situation like this
if I want to start with a grid ordered by CustomerID I found useful start with a RadDataServiceDataSource AutoLoad set to false,
set my sort descriptor, than, when DataPager.Loaded occours, invoke Load() on the RadDataServiceDataSource and set AutoLoad to true.

Any better solution is welcome.

[Maya]

Hi Max,

You can also take a look at this forum thread for further reference.
I hope that helps.

Regards,
Maya
Telerik