virtualization

[Adam Walocha]

Is possible to bind IQueryable data source to your grid in such way that it loads record from data source in fragment? Now when i bind collection, that implements IQueryable, grid retrievies all record (in my case it takes up to 2 minutes ).

[Vlad]

Hello Adam,

Please check this demo (you need to download and run our examples locally) for more info:
http://demos.telerik.com/wpf/?GridView/WPF/Performance/ServerSide

Kind regards,
Vlad
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.

[Adam Walocha]

While testing virtualization i meet following problem:
when  i try do change page i get exception:
"The method 'Skip' is only supported for sorted input in LINQ to Entities. The method 'OrderBy' must be called before the method 'Skip'."
I don't use method 'order by' and 'skip.
Code:

binding:
            QueryableCollectionView view = new QueryableCollectionView(presenter.Model.EntityList);
            view.PageSize = 1000;
            MessageBox.Show(view.TotalItemCount.ToString());
            radGridView1.ItemsSource = view;
change page:
            i++;
            ((QueryableCollectionView)radGridView1.ItemsSource).MoveToPage(i);

presenter.Model.EntityList implements IQueryable<Product> and class product derives from class EntityObject

[Vlad]

Hi Adam,

Indeed with LINQ to Entities if you want paging you should provide default sorting.

Sincerely yours,
Vlad
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.