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!
<Schema 
  Namespace="MobileNordic.MobileCMS.Domain.Store"
  Alias="Self"
  Provider="System.Data.SqlClient"
  ProviderManifestToken="2005"
  xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator"
  xmlns="http://schemas.microsoft.com/ado/2006/04/edm/ssdl">

Tags: ,

Entity Framework | SQL Server

blog comments powered by Disqus

About the author

Life architect specialized in programming