GridView - load data on demand

[Roee]

Hello All.

We have a wpf client application (xbap) with a custom Grid which display billions of records.
We implemented data load on demand, when we only fetch (load) the current page into the client.
We also support sorting and filter on the entire data at server side, and filter data for our excel like filters from all the records.

We would like to move into telerik wpf controls, what is the way to achieve such a behavior using telerik wpf controls?

Thanks
Roee

[Milan]

Hi Roee,

First of all I would like to thank you for your interest in our WPF offering and we will be glad to have you as a customer. 

Our grid's data engine is designed to work directly with the server when used with LINQ to SQL, ADO.NET Entities, or any other standard LINQ provider which means that there is no problem to work with large amount of data without any performance degradation.

For example, when working with ADO.Net Entities operations like sorting filtering, grouping will be executed on the server which is a must have for the scenario that you have described. Coupled with our UI virtualization mechanism you should find RadGridView as a great replacement for your current custom grid.

Here is a list of several demos that you might find interesting:

Paging

Performance - Paging, Grouping, Filtering, Sorting on the server - unfortunately this example could only be ran locally by installing our Trial installation package and then running our demos. 

Do not hesitate to write if you have any further questions. 

Kind regards,
Milan
the Telerik team

[Roee]

Hello Milan, thanks for your answer.

I'm afraid this approach has problems in our case.
Our client application can't directly access the database server due to network segmentation, permissions and so on.

Our xbap (wpf client) can only access our application server (we use wcf for this), which then communicate to the database.
This is our flow:
Xbap --(WCF)--> Application Server (Buisness Logic) --(DB Connection, ORM) --> Remote database

I was looking at your DomainDataSource examples, but it seems they're only for Silverlight.

By the way - we already have Telerik controls for WPF.

Thanks,
Roee

                                           

[Milan]

Hello Roee,

it seems that I have missed that the application is XBAP. Excuse me for that. 

I have prepared a sample which uses a WCF service to retrieve data from a database using Linq to SQL. Operation like paging, sorting, grouping, are all performed on the server and only the needed data is fetched. 

I hope this sample is helpful.

All the best,
Milan
the Telerik team

[Roee]

Thanks very much for the answer, it helps a lot.

One question if I can: In your answer you wrote you have used WCF Data Services, and I could find other Telerik examples where it was used, but in the end, you implemented using Dynamic Linq.
Since I myself debating between Dynamic Linq and WCF Data Services, can you please give a few pointers to help me with my decision?

Yours,
Roee

[Milan]

Hi Roee,

Well, the example uses WCF service but contains some custom code which enables server-side sorting, filtering, and grouping. 

Kind regards,
Milan
the Telerik team