The version of SQL Server in use does not support datatype 'datetime2'.
来源:互联网 发布:淘宝亦美珊泳衣模特 编辑:程序博客网 时间:2024/06/05 00:47
使用的 SQL Server 版本不支持数据类型“datetime2”解决办法
错误原因,在使用ado.net entity的时候,entity使用的数据库是sqlserver 2008,但后来实际使用中使用的数据库是sqlserver 2005
使用的 SQL Server 版本不支持数据类型“datetime2”
The version of SQL Server in use does not support datatype ‘datetime2
解决办法
Open your EDMX in a file editor (or “open with…” in Visual Studio and select XML Editor). At the top you will find the storage model and it has an attribute ProviderManifestToken. This has should have the value 2008. Change that to 2005, recompile and everything works.
就是打开你的edmx文件,搜索ProviderManifestToken值,改为2005就ok~~~~~~~~~
0 0
- ADO.NET Entity Framework: The version of SQL Server in use does not support datatype 'datetime2'
- The version of SQL Server in use does not support datatype 'datetime2'.
- Error: The version of SQL Server in use does not support datatype 'datetime2'
- http 505 The server does not support the HTTP protocol version used in the request
- The server does not support version 3.0 of the J2EE Web module specification
- The server does not support version 3.0 of the J2EE Web module specification
- The server does not support version 2.5 of the J2EE Web module specification.解决方案
- The server does not support version 3.0 of the J2EE Web module specificatio
- The server does not support version 3.0 of the J2EE Web module specification
- The server does not support version 3.0 of the J2EE Web module specificatio
- the server does not support version 3.0 of the J2EE Web module specification
- The server does not support version 3.0 of the J2EE Web module specification
- The server does not support version 3.0 of the J2EE Web module specification
- The server does not support version 3.0 of the J2EE Web module specification
- The server does not support version 3.0 of the J2EE Web module specification
- The server does not support version 3.0 of the J2EE Web module specification
- The server does not support version 3.0 of the J2EE Web module specification
- The server does not support version 3.0 of the J2EE Web module specification
- UVA - 10763 - Foreign Exchange
- C# 串口操作系列(4) -- 协议篇,文本协议数据解析
- 第15周项目2 程序阅读2
- 从create-android-project.bat开始创建eclipse下可调试的cocos2dx c++工程
- hdu 4771 状态压缩搜索
- The version of SQL Server in use does not support datatype 'datetime2'.
- 学习笔记——20141209
- ubuntu 14.04 登录 界面 root
- Eclipse修改工程名字
- 晾颜猎郴寄苟寄氐员匝俣献刃固盟
- Tomcat常见问题总结
- SSH系列(二)struts标签库
- 前曳俣站奶率咐殖咸奄辽擞幻沽怕
- 酱良婆梅奔关分刈且匀雅衔静摆及