I have a kendo grid that uses paging on the ajax read. The dataset is too large for me to realistically load completely into memory, but my view model has a couple of intensive calculated fields.
Ideally, I would like the ToDataSourceResult KendoUI extension to work on the IQueryable so the filters and paging from the grid don't work on the entire dataset, but so I can populate the intensive calculated fields on the results that need to be returned.
Alternatively, if I could continue to use kendoui's paging ui, but handle it manually on the controller I could turn off the kendui filtering. It seems that the ToDataSourceResult would either duplicate any paging I did, or it would remove the paging from the UI.
What is the suggested way to handle this?