海洋工作室——網站建設專家：The version of SQL Server in use does not support datatype datetime2 and the Entity Fr

 

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