EF强制生成SQL 2008兼容的SQL语句
问题描述
开发项目用的SQL为SQL2012版本
发布后，查询语句报错，
检查服务器服务器为SQL2008
获取生成的SQL语句为：
SELECT [Extent1].[isid] AS [isid], [Extent1].[rowID] AS [rowID], [Extent1].[APIName] AS [APIName], [Extent1].[url] AS [url], [Extent1].[checkType] AS [checkType], [Extent1].[dataAuthorize] AS [dataAuthorize], [Extent1].[createUser] AS [createUser], [Extent1].[createTime] AS [createTime], [Extent1].[importTag] AS [importTag] FROM [dbo].[base_APIList] AS [Extent1] ORDER BY row_number() OVER (ORDER BY [Extent1].[url] ASC) OFFSET 0 ROWS FETCH NEXT 50 ROWS ONLY
GarsonZhang www.yesdotnet.com
此语句需要SQL2012支持，SQL2008不支持此语句
解决方案：
用记事本打开模型文件,osap.edmx
修改 ProviderManifestToken
版权声明：本文为YES开发框架网发布内容,转载请附上原文出处连接
post YES开发框架
