I am new on Telerik and especially on OpenAccess;
I am starting on port applications and I need to understand how I can obtain the best result on data fetching;
I am talking on WPF (Silverlight in the second time) and OpenAccess;
If want simply query a large data table of 1 million of record and 100 columns (I start with tests, like everybody);
You tell us about performances, data virtualization, and asyncronous load in grids......but, if I use a Radgrid with all performances options on, and I launch a simple Linq select on that table, the resut is the server hang-up because OpenAccess generate a select for all records.
How I can query (without my intervent and without filter the table in the application) and fetch "incrementally" data without crash the data server ?
I have tried Devexpress components (I am a fan of Devexpress and Telerik components) and their approach is perfect: the grid generate (via Server-mode) sql for fetch only few necessary records for fill UI, even if I have request all records, so the server resources are preserved because it is queried "on demand" when I scroll the grid.
How I can obtain a similar result with RadGrid (Wpf) and OpenAccess?
Thanks in advance,
(sorry for my english).
Stefano Monterisi
Sestante Bulgaria
6 Answers, 1 is accepted
You could bind the RadGridView.ItemSource property to a QueryableCollectionView of items. The QueryableCollectionView represents a view for grouping, sorting, filtering and paging data collection using Linq base query operators:
this
.RadGridView1.ItemsSource =
new
QueryableCollectionView(context.Customers);
You could find useful the provided from us sample application.
Sincerely yours,
Damyan Bogoev
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
You can follow the Henrik's idea. The Data Services Wizard is available here.
If any questions arise please contact us back.
Greetings,
Damyan Bogoev
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
thank you for the help.
Now what I need for migrate from desktop app to Silverlight is a grid that can 'paging' transparently to user; so the paging must be managed by the vertical scrollbar and the virtualization must be the rest.
The user, then, can scroll millions of records as they are already on the client. This is the devexpress server-mode approach and it is very powerful.
My customers avoid paging on intensive applications...:-)
Another need (and I think those are basic request for professional LOB in the real world) is a direct incremental search on grid columns, and an incremental filter.
Now this a leak features in your grid, but I cannot start projects with those features; Otherwise I have to change my application concept.
Thanks,
Stefano Monterisi
Sestante
Our data engine can fully utilized the power of SQL servers and combined with our powerful virtualization mechanism you can works with millions of records at a time. This sample demonstrates how our virtualization mechanism can handle 50 million cells. We currently do not have a built-in mechanism of adjusting the page-size using the vertical scrollbar but one of my colleagues has blogged about implementing this functionality with just a few lines of code.
The incremental search and filter features are not provided out of the box but they can be implemented without too much effort. We have a "Search as you type" example which demonstrates this type of filtering. We currently do not have an example of incremental search but we could prepare such sample for you we just need some more information about the behavior that is expected.
Hope this information is helpful.
Regards,Milan
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.