Thursday, March 1, 2012

Tips: The version of SQL Server in use does not support datatype 'datetime2'

If you are using edmx model and you see this error, it means your database reference is not right. This happens when you update your edmx from another version of sql server and then run on different version.

  1. Right click edmx model
  2. Select edit with option
  3. select xml editor from the dialog menu
  4. Change ProviderManifestToken at the top to reference 2005 like this:
    1. <Schema Namespace="YOUR_DBModel.Store" Alias="Self" Provider="System.Data.SqlClient" ProviderManifestToken="2005" 

No comments:

Post a Comment

Let me know what you think?