This project is read-only.

SQL Server 2008 support?

Sep 18, 2015 at 3:11 PM

when I try to use Grid.Mvc with the SQL Server 2008 I am getting error - [SqlException (0x80131904): Incorrect syntax near 'OFFSET'.
Invalid usage of the option NEXT in the FETCH statement.
Incorrect syntax near 'OFFSET'.

Does it means, Grid.MVC is not supported on SQL Server 2008 only on 2012?

Thank you
Sep 21, 2015 at 6:56 PM
I found solution - issue was related to LINQ not to Grid.MVC. In model definition EDMX file is needed to change ProviderManifestToken from 2012 to 2008.

<Schema Namespace="ComplianceRiskModel.Store" ProviderManifestToken="2012" Provider="System.Data.SqlClient" ...>
Marked as answer by lendy on 9/21/2015 at 10:56 AM