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

asp.net c# entity-framework

Question

In an ASP.NET 4.0 Web Form, I'm using the Entity Framework 4.0.

On the test server, everything is in order. However, same mistake is recorded by my Elmah when I reach the production server.

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

I quickly looked into this and discovered thatdatetime2 aka datetime2(7) the issue and environmentProviderManifestToken="2005" will find a solution.

This is my issue. My Production Server has SQL Server Express 2008, whereas my Development Server has Data Warehouse 2008 R2. So it doesn't seem appropriate to change the manifest to 2005.

My inquiries are

  1. Will it set?ProviderManifestToken="2005" work?
  2. Why did Entity Framework produce this?datetime2 if I haven't used it in any of the tables at all?
  3. Is there a better solution to this?
1
4
7/1/2011 10:57:38 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

I have yet to come across a solution. Therefore, if you're using SQL Server Express 2008, please right-click on your edmx file, open it in an XML (Text) Editor, and setProviderManifestToken="2005" .

Not that nice of a sound. But for now, it is all I have.

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

Popular Answer

The solution provided in this blog article, The current version of SQL Server does not support the datetime2 datatype., seems to work for me.

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 brief search on Google leads me to what seems to be the ...solution.......Open your EDMX in a file editor (or choose XML Editor under "Open With" in Visual Studio). The storage model is located at the top and contains the attribute ProviderManifestToken. 2008 should be the value of this. Make that 2005, recompile, and everything will work....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 came across this restriction, I switched 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 successful in doing this by placing each...edmx... in an independent assembly. then swap out all of the in the connection string....res://*/...... with ...res://NameOfAssembly/......In fact, I can combine the two entity models together (contrary to assertions I saw in other sources), for example:...var oneDb = new Entities2000(); var otherDb...
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.

If your database columns are Datetime, this might be an issue since Entity Framework treats all dates as a Datetime2. The most common fixes, according to what we discovered after experiencing the identical issue, are to fill in all the date fields and change the datatype.
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, but I still received the problem. But after including this in my connection string, everything 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

The DDEX provider is installed for you by the SQL Server Compact Toolbox, which you must install on the new development machine. (You might need to open the Toolbox's About screen, click the DDEX install button, and then restart Visual Studio.)
ef-database-first entity-framework-6 git sql-server-ce-4
asked by ErikEJ

Entity Framework Code First: which DataType attribute for DateTime2?

ZZZ_tmp
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'

SQL Server 2005 is not supported by EF Core, although versions 2012 and beyond are...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 typical data format for...string... is columns...nvarchar(MAX)... there is no need for you to change the data type in your columns before converting to...NVARCHAR(MAX)... . Ef has Specify default conventions. Knowing conventions is explained by the number ...here.......If you want a standard configuration for your models, you may follow these s...
.net entity-framework entity-framework-6 sql sql-server
asked by Soheil Alizadeh

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

ZZZ_tmp
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