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.
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
0
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
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
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.
Binding to IQueryable is vastly easier. Thanks.