[Solved] Custom Paging and Sorting in Entity Framework 4

[kencox]

Hi folks,

Could someone point me to a sample of doing custom (server-side) paging and sorting using RadGrid and Entity Framework 4?

I've seen samples that call a stored procedure but nothing on plain EF4 (VB preferred).

Thanks,

Ken

[improwise]

Actually, it depends on how you are using EF4, are you using the EntityDataSource or making a "real" application with Business Layer etc? If you are using EntityDataSouce, paging and sorting is done for you and works very well with RadGrid etc, but its mor tricky if you use ObjectDataSource or similar (which of course has many other great advantages).

[kencox]

Hi Patrik,

Thanks for your response.

I used the EntityDataSource for quick development but RadGrid appears to fetch all the data and then do the filtering and sorting on the client. That's suitable for a small amount of data but not for a huge number of rows.

There's a useful example in the Code Library called True Custom Paging and Sorting. I'm trying to do the same thing strictly in Entity Framework 4. (That is, without the use of the SQL stored procedure and DataTable.)

I've been making progress on reproducing this functionality on my own, but I had hoped someone had already invented this wheel using EF4.

Ken

[Nikolay Rusev]

Hello Ken,

If you are using EntityDataSource RadGrid will apply all filtering/sorting/paging on the data source and only PageSize items will be returned to server. For your convenience I've prepared sample demonstrating RadGrid binding to EntityDataSource with paging/sorting/filter. If you perform one of those operations Label will be updated with Count of the records returned to RadGrid.

Regards,
Nikolay
the Telerik team

[Satish]

yy