海洋工作室——网站建设专家：The version of SQL Server in use does not support datatype datetime2 and the Entity Framework.

 

by mikael 1. January 2009 19:00

This is due to the edmx file being generated or updated from a SQL 2008 instance and run against a SQL 2005 instance. I tried about every trick I could think of before reading about it here. Basically all you need to do is to open the EDMX file with XML Editor and change ProviderManifestToken=”2008” to ProviderManifestToken=”2005”. Thanks a bunch Alex Duggleby for the hint!

view source

print?

1.<Schema 

2.  Namespace="MobileNordic.MobileCMS.Domain.Store"

3.  Alias="Self"

4.  Provider="System.Data.SqlClient"

5.  ProviderManifestToken="2005"

6.  xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator"

7.  xmlns

 

原文地址： http://blog.zoolutions.se/post/2009/01/01/The-version-of-SQL-Server-in-use-does-not-support-datatype-datetime2-and-the-Entity-Framework.aspx