We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Datasource sublists

Thread ID:





88518 Jul 28,2009 12:45 PM UTC Jul 29,2009 06:14 PM UTC ASP.NET MVC (Classic) 4
Tags: Grid
Eric Swann
Asked On July 28, 2009 12:45 PM UTC

Hello, I'm using an ORM (LightSpeed) for my datasource. The object I'm using as the basis of my datasource is a domain object with several subcollections which are automatically lazy loaded on demand by the ORM.

What I've found is that when the grid binds to my datasource, the grid interrogates all of these subcollections, even though none of them are set up as grid columns. This causes my entire object graph to load which is obviously very bad for performance reasons. Is there a way to turn this functionality off in the grid? Otherwise I'll have to create a special class just for binding to the grid, which I'd like to avoid.


Balaji K [Syncfusion]
Replied On July 29, 2009 10:01 AM UTC

Hi Eric,

Thank you for using Syncfusion Products.

Please find the same query update in the following forum



Eric Swann
Replied On July 29, 2009 12:23 PM UTC

Hello Balaji,

Unfortunately my question is completely different from the one answered in the other post.

What I am saying is that the grid automatically accesses all of my model properties....even the ones that are not mapped to columns when it databinds. This causes my entire object (including all subcollections) to lazy load from my database when the grid is bound.

I believe the grid is trying to help me by automatically detecting subcollections, but with any ORM based object out there this is going to absolutely kill site performance.

I want to ***prevent*** this from happening. Is there a way to disable this in the grid so that it doesn't automatically try to determine all of my subcollections?


Eric Swann
Replied On July 29, 2009 01:26 PM UTC

Essentially what I did to accomodate this was to make a specific ViewModel without all of my collections to bind to the grid using Automapper:

Balaji K [Syncfusion]
Replied On July 29, 2009 06:14 PM UTC

Hi Eric,

We regret to let you know that we don't support lazy load option.

The mentioned way would be a work around for now and the request has been considered as a feature request and has been forwarded to our development team for further analysis.

You can expect this feature in the future release.



This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon