XtraGrid using LINQ to SQL in Server Mode

[Sam Grow]

I just started evaluating OpenAccess and so far it looks great. I currently use the DevEx Grid control v9.1 in the Server mode with LINQ to SQL and it's amazingly fast loading 100,000 records into the grid in about 1 second. They are obviously doing some kind of lazy loading by retrieving only the data that you can see in the grid. Then as you scroll, it automatically gets the data required to display in the grid simulating all 100,000 are actually loaded in the grid. I was wondering if there was a way to bypass LINQ to SQL and use OpenAccess to do the same thing?

It appears the Telerik grid control can do this but unfortunately my project is using the DevEx controls with their themes so I cannot switch the controls without a lot of work.

All I need is for this to be a read only grid but it must be able to display large amounts of records that a user can scroll and up and down and see all the data.

Thanks,
Sam

[Dimitar Kapitanov]

Hi Sam Grow,
We have a LINQ support as well. It means that you can prepare your LINQ queries and run them on the server against Telerik OpenAccess ORM exactly the same way as with Linq To Sql. Please let me know if there are any problems that you encounter during your implementation. Also we will be launching new site for the Q3 release that will contain a lot of video and code support materials, it will definitely ease the learning curve for Telerik OpenAccess ORM.

Regards,
Dimitar Kapitanov
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.

[Sam Grow]

Hi Dimitar,

Thanks for the reply.  I have a follow-up question on your controls.

Can you confirm if it's possible to do this with your Telerik controls if I did decide to switch controls?  In other words, do your Grid and Combo Box controls work with OpenAccess to where they could load lets say 250,000 records in a scrollable list fast?  I do not mean paging, but instead a grid control and combo box control that would have a scroll bar that I could slide half way down and be on record 125,000 of 250,000?

I would really like to see a demo of this if they can, in both your Windows and Silverlight.

Thanks,
Sam

[Alexander]

Hello Sam Grow,

I am glad to see that you are interested in our controls. The load on demand effect is achievable right out of the box with our Rad Controls for Windows Forms and OpenAccess ORM. All you need to do is to bind a RadGridView to an OpenAccess ObjectView. This can be seen in our Fetch plan and Tracing example from the Windows Forms Quick Start application distributed with Telerik OpenAccess ORM. This can be achieved by using a RadMultiColumnComboBox as well. The RadMultiColumnComboBox itself contains a grid which has the same virtualization capabilities as the RadGridView.
Unfortunately the RadGridView for Silverlight does not yet support load on demand with scrolling, the option here would to use paging instead. For more details you can take a look at the Performance examples for Silverlight. Virtualization example for the Silverlight ComboBox is available as well in this blog post. Additionally, an integration example of OpenAccess and the Rad Controls for Silverlight controls could be found here.
Please, let us know if you need any further information.

All the best,
Alexander
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.