Does Editor v1.5.1 (.Net) server side processing work with SQL Server 2008 DB?
Does Editor v1.5.1 (.Net) server side processing work with SQL Server 2008 DB?
ketan.asu
Posts: 1Questions: 1Answers: 0
I tried to use Editor v1.5.1 server side processing.
I am using it with ASP .NET Web API and SQL Server 2008 Database.
When I use server side processing option for DataTable (for pagination, search and ordering) I keep getting error.
Does Editor v1.5.1 (.Net) server side processing work with SQL Server 2008 or is it compatible only with SQL Server 2012?
This discussion has been closed.
Answers
Server-side processing in the Editor libraries uses LIMIT and OFFSET which were introduced in 2012, so yes, the .NET server-side processing requires SQLServer 2012.
It would be possible to write your own custom server-side processing script using the old TOP etc method of 2008 to limit results, but I found that SQL syntax horrible to work with!
Allan