Today I was a little bit confused about a error message “…conversation error for datetime2 in datetime…”. Because in my database scheme I am not using any new SQL Server 2008 datetime2 data types. After a while of researching, I found out that the Entity Framework 4 internally works with the datetime2 data type and wants to convert it in my datetime database type.
To use the datetime data type in Entity Framwork 4 you have to switch the ProviderManifestToken in the edmx-file to "2005". After thisn the Entity Frameweok 4 will work with the datetime data type.