摘要： 最近.Net Core程序部署到服务器，采用EF6。本地数据库是SQL server 2016，服务器数据库安装的是SQL server 2008 R2，在用到分页查询时报错如下： { "Depth": 0, "ClassName": "", "Message": "Incorrect syntax near 'OFFSET'.\r\nInvalid usage of the option NEXT in the FETCH statement.", "Source": "Core .Net SqlClient Data Provider", } 阅读全文