I am using DataTables.net with server-side via WebForm and Ado.net.
I need to page the data (sort, filter, etc), I see 2 possibilities:
- via stored procedure
ou
- via DataView
The problem is that when using DataTables.net it sends me 62 fields through the Querystring in which I will have to treat and mount the possible pages, I believe that via StoredProcedure it will be a monster to do that.
Usually the number of records varies from 400 to 3 thousand.
It is not very feasible to put the Entity Framework only to solve this problem.
What do you recommend? I'm propensing to start developing in DataView with RowFilter, Sort, etc.
NOTE: Today DataTables calls a Generic Handler in which I query the database and return the result via JSON