This is a migrated thread and some comments may be shown as answers.

Server side paging/sorting/filtering using ServiceStack Ormlite

2 Answers 123 Views
GridView
This is a migrated thread and some comments may be shown as answers.
Datafyer
Top achievements
Rank 1
Veteran
Datafyer asked on 28 Sep 2014, 02:24 AM
I am using ServiceStack Ormlite for my data access and have a table with several million rows of data. Downloading this all locally to display in the RadGridView is not a good solution.

I have spent several hours now trying to figure out how to convert the FilterDescriptors and SortDescriptors to linq so that I can use them in Ormlite. It seems this is impossible. I have also tried the VirtualQueryableCollectionView, but run into the same issues.

The only solution I see now is to use EntityFramework for this data which I really don't want to do.

2 Answers, 1 is accepted

Sort by
0
Nick
Telerik team
answered on 01 Oct 2014, 01:14 PM
Hello Patrick,

The whole data engine of RadGridView uses LINQ to function, so as long as your data is consumed as Queryables, you should be able to filter/sort/page on the server. 

I cannot say what exactly goes wrong in your case, based on the information you have provided. Can you share what is the exact GridView configuration and data source? 

Regards,
Nik
Telerik
 
Check out Telerik Analytics, the service which allows developers to discover app usage patterns, analyze user data, log exceptions, solve problems and profile application performance at run time. Watch the videos and start improving your app based on facts, not hunches.
 
0
Datafyer
Top achievements
Rank 1
Veteran
answered on 03 Oct 2014, 11:25 PM
I did not realize this earlier, but RadGridView can be bound directly to an IQueryable. I was instead trying to attached to the sort/filter/page events then translate that info to sql in order to pass it to the backend. This did not work at all.

Binding to IQueryable is vastly easier. Thanks.
‚Äč
Tags
GridView
Asked by
Datafyer
Top achievements
Rank 1
Veteran
Answers by
Nick
Telerik team
Datafyer
Top achievements
Rank 1
Veteran
Share this question
or