Use Grid without ToList()

[Joao]

Hi there,

I have a very huge database and want to use Syncfusion Grid.

The problem is that all examples that I have seen all need to retrieve the whole database first, I couldnt find any example to query database ondemand.

I can't query the whole table all the time, is there any way to achieve this?

Cheers

[Satheeskumar S]

Hi Joao,

 

Thanks for your interest in Syncfusion products.

 

If you are using IQueryable, every time the data is fetched from the database in OnDemand not the whole data. We have created a sample using IQueryable to avoid fetching full records from database and to avoid ToList().

We suggest you to refer our Online Sample and Online Documentation for EnableOnDemand.

Please visit the below links.

Online Sample- http://mvc.syncfusion.com/demos/ui/grid/DataBinding/CustomBinding

Online documentation- http://help.syncfusion.com/ug/asp.net%20mvc/grid/default.htm#!documents/custombinding.htm

In our online sample we have used IEnumerable, so we use ToList (). Then we have converted to IQueryable so the data fetching will be in on demand basis.

 

For your convenience we have attached a sample. Could you please use this sample and get back to us if you have any queries.

 

Please let us know if you have any other concerns.

 

Regards,

Satheeskumar S

EnableOnDemand_42370a89.zip