Entity Framework Error: The SQL Server version in use does not support the datatype 'datetime2'.

asp.net c# entity-framework

Question

I am using Entity Framework 4.0 in an ASP.NET 4.0 Web Form.

All is fine on the development server. But when I get to the production server, I my Elmah logs this error

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

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

My problem is this. My Development Server has SQL Server 2008 R2 and Production Server has SQL Server 2008 Express. So, changing the manifest to 2005 doesn't seem right.

My questions are

  1. Will setting ProviderManifestToken="2005" work?
  2. Why has Entity Framework generated a datetime2 when I haven't used it at all in any of the table?
  3. Is there a better work around?
1
4
7/1/2011 10:57:38 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

I dont see any workaround till date. So if you are using SQL Server 2008 Express, please right click on your edmx, open it with XML (Text) Editor and set ProviderManifestToken="2005".

Doesn't sound that good. But its all I have got as of now.

23
7/5/2011 7:43:31 AM

Popular Answer

I found that the answer in this blog post worked for me: The version of SQL Server in use does not support datatype 'datetime2'

It turns out that Entity Framework 4 somehow got the idea to use SQL Server 2008. The fix was to edit the .edmx file in an XML editor and set the ProviderManifestToken="2005" instead of 2008. (You need to rebuild.) Here’s how the line should look against SQL Server 2005:

<Schema Namespace="OfficeBookDBModel.Store"
    Alias="Self" Provider="System.Data.SqlClient"
    ProviderManifestToken="2005"
    xmlns:store=http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator
    xmlns="http://schemas.microsoft.com/ado/2009/02/edm/ssdl">
Yann Duran

Related Questions

Date time and SQL Server 2008 and SQL Server 2005

A quick google points me to what looks like the ...solution.......Open your EDMX in a file editor (or “open with…” in Visual Studio and select XML Editor). At the top you will find the storage model and it has an attribute ProviderManifestToken. This has should have the value 2008. Change that to 2005, recompile and everything works....NOTE: ...
datetime datetime2 entity-framework sql-server-2005 sql-server-2008
asked by Richard Harrison

SQL Server Compact does not allow keys and values produced by the server.

When I hit this limitation, I changed the type to uniqueidentifier
compact-framework entity-framework
asked by mostlytech

Multiple SQL Server versions in a single ASP.NET application utilizing Entity Framework

I was able to accomplish this by putting each ...edmx... in a separate assembly. Then in the connection string, replace all the ...res://*/...... with ...res://NameOfAssembly/......I can even perform joins between the two entity models (contrary to claims I found in other sources), e.g.:...var oneDb = new Entities2000(); var otherDb = new Entities2...
entity entity-framework sql-server-2000 sql-server-2005
asked by Cogwheel

When utilizing entity framework with Visual Studio 2010.net 4.0, you get a 'datetime2' issue.

Entity framework handles all the dates as a Datetime2, so, if your fields in the database are Datetime, this could be a problem. We had the same problem here, and from what we found, populating all the date fields and changing the datatype, are the most commom solutions
c# entity-framework sql-server sql-server-2008
asked by Tejo

How can I fix Azure? "This version of SQL Server does not allow Windows logins"?

I was using user/pass and still got the error message. But, I added this to my connection string and it worked....Trusted_Connection=False;Encrypt=True;
asp.net-mvc azure-sql-database c# entity-framework sql-server
asked by JoshYates1980

Entity Framework 6.1.3 and SQL Server CE 4.0 - No Entity Framework provider found

You need to install the SQL Server Compact Toolbox on the new dev machine, it installs the DDEX provider for you. (You may have to go to the About screen in the Toolbox and clikc the DDEX install button, then restart VS)
ef-database-first entity-framework-6 git sql-server-ce-4
asked by ErikEJ

Entity Framework Code First: which DataType attribute for DateTime2?

The DataType attribute is not used for column type mapping for Code First...:...The Column annotation is a more adept in specifying the attributes of a mapped column. You can stipulate a name, data type or even the order in which a column appears in the table. [...] Don’t confuse Column’s TypeName attribute with the DataType DataAnnotation. ...
c# dbcontext entity-framework
asked by CodeCaster

Error ASP.NET Core EF Core and SQL Server 2005: The version of SQL Server in use does not support datatype 'datetime2'

EF Core does not support SQL Server 2005, but 2012 and forward...https://docs.microsoft.com/en-us/ef/core/providers/sql-server/
asp.net-core-mvc entity-framework entity-framework-6 sql-server-2005
asked by ErikEJ

Disable conversion between VARCHAR and NVARCHAR when using Entity Framework over an existing SQL server database

The default data type for ...string... columns is ...nvarchar(MAX)..., you don't have the need to set data type in your columns for changing to ...NVARCHAR(MAX).... Ef has default conventions that Specify it. ...here... is explained for knowing conventions....if you want config generally convention for your models, you can do this:...public class D...
.net entity-framework entity-framework-6 sql sql-server
asked by Soheil Alizadeh

'Option not supported' error when using SQL Server with MySQL

The issue is that we are using ...MySql.Data.Entity.MySqlEFConfiguration... (in the ...app.config...) which set the default connection factory to use ...MySqlConnectionFactory.......The solution is to use a custom ...DbConfiguration... in place of ...MySql.Data.Entity.MySqlEFConfiguration... to deter from setting the default connection factory....p...
c# entity-framework-6 mysql sql-server
asked by Noctis Tong

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow