Home > ASP.NET > Using a EF model generated from SQL Server 2008 against SQL Server 2005

Using a EF model generated from SQL Server 2008 against SQL Server 2005

If you have generated a SQL Server 2008 EF model and are migrating the EF to SQL Server 2005, chances are you will receive the following error

The version of SQL Server in use does not support datatype ‘datetime2′.

This is a known issue and the fix is relatively simple.

Open your edmx file, and on the top line, you can find an attribute called ProviderManifestToken, change it from 2008 to 2005 and you are good to go!

Advertisements
Categories: ASP.NET
  1. May 29, 2011 at 8:39 pm

    Is extremely good article

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: