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!