The version of SQL Server in use does not support datatype 'datetime2'

Sometime we face Sql server  version not support datetime2 errer in entity framework when we run application .

 I did a quick research and found out that datetime2 aka datetime2(7) is the problem and settingProviderManifestToken="2005" will solve the issue.

Solution:-

we have to change SQL server version in edmx file.right click on your edmx, open it with XML (Text) Editor and set ProviderManifestToken="2005"

will work proper.