The SQL Server version used does not support data type ' datetime2 ' workaround

Error reason, when using the ADO entity, the database used by entity is SQL Server 2008, but then the database used in the actual use is SQL Server 2005
The SQL Server version used does not support data type ' datetime2 '

The version of SQL Server in does datatype ' datetime2
Solutions
Open your EDMX in a file editor (or "open With ..." in Visual Studio and select XML Editor). At the top you'll find the storage model and it has an attribute ProviderManifestToken. This had should has the value 2008. Change this to 2005, recompile and everything works.

is to open your edmx file, search for the ProviderManifestToken value, and change it to 2005 ok~~~~~~~~~

Reprinted from: http://blog.csdn.net/soulzx/article/details/6756723