I genereated ADO.Net Entity framework edmx using SQL Server 2008 version. When i pointed my application to SQL Server 2005 with the same database schema got error saying
SQL Server in use does not support datatype datetime2.
解决方法:2008 to 2005.
<
edmx:Runtime>
<!-- SSDL content -->
<
edmx:StorageModels ><
Schema Alias = " Self " Provider = " System.Data.SqlClient " ProviderManifestToken = " 2005 " ></Schema>
</edmx:StorageModels>
- Enjoy