XtraGrid LINQ to SQL Server Mode Support

Posts   
 
    
sdgrow
User
Posts: 11
Joined: 01-Nov-2009
# Posted on: 01-Nov-2009 23:21:59   

I just started evaluating LLBLGen 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 LLBLGen to do the same thing?

I read some posts from over a year ago about others trying to do the same thing but I could not determine if this was ever possible.

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

Walaa avatar
Walaa
Support Team
Posts: 14993
Joined: 21-Aug-2005
# Posted on: 02-Nov-2009 10:52:05   

Have you checked this thread: http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=13923

As the user have reported later on another thread that it is working perfectly with him: ref: http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=15589&StartAtMessage=0&#86969

sdgrow
User
Posts: 11
Joined: 01-Nov-2009
# Posted on: 05-Nov-2009 05:49:17   

From what I have read, the project I am working on would be best served using the Adapter template since eventually it would require web services.

However, the documentation makes it sound like in order to to do what I am looking for I would have to use the SelfServicing Template. I guess the whole Templates thing confuses me.

I get the impression that if I pick the wrong template I could be sorry down the road if I need a feature that is not supported by that template.

Sam

Walaa avatar
Walaa
Support Team
Posts: 14993
Joined: 21-Aug-2005
# Posted on: 05-Nov-2009 10:19:30   

Your templates question was answered in the other thread. Generally you won't miss anything if you use the Adapter, as it gives you more control over what's going on.

sdgrow
User
Posts: 11
Joined: 01-Nov-2009
# Posted on: 05-Nov-2009 18:41:02   

Thanks for the help. sunglasses

MTrinder
User
Posts: 1461
Joined: 08-Oct-2008
# Posted on: 05-Nov-2009 21:41:08   

That's what we're here for...!

Matt