Example of asynchronous loading grid data

[Marcin]

Hello
I was looking through these forums, demos and google for any example of proper usage entity framework (for .NET 4 and .NET 4.5) with async data loading.

Lets look into requirements:
1. Database with 1 mln record (just to mention large amount of data)
2. EntityFramework (ObjectContext), with entity name "Product"
2. GridView on window.
3. DataPager assigned to GridView (100 per page)
4. BusyIndicator on window.

Requirement:
1. On window open - start asynchronous (to make UI responsible)  data loading with assigning IsBusy of BusyIndicator to true.
2. Once data loaded set IsBusy to false.
3. On page change, sort, filter - assign IsBusy to true when stared, and to false when ended.

So idea is quite simple for responsive UI. However I couldn't any example of such scenario.
The EnityFrameworkDataSource is totally synchronous and does not contain way to assign IsBusy and if there is delay UI stops responding.

Regards
Marcin

[Dimitrina]

Hello Marcin,

What I can suggest you to check the WPF Demos with RadEntityFramework DataSource. Our control still does not have such asynchronous support though.
I have passes the question to the development team for a further investigation.

Regards,
Didie
Telerik

[Marcin]

Hello
Yes, I already looked there, and found nothing useful that would allow me user Grid out of box with server filtering and paging and sorting, without too much coding.

I know I can use pager in detached mode which would give me a way to simulate async with background worker. But what with sorting and filtering. How can get get current filters and sorts and apply them to my IQueryable?

Kind Regards
Marcin

[Yoan]

Hello Marcin,

As you already know the EnityFrameworkDataSource does not support asynchronous mode. However, we will consider implementing this functionality in one of our upcoming releases.

Thank you for the feedback and let us know if you have other questions.


Regards,
Yoan
Telerik