Entity framework error: A datetime2 data type was converted to a datetime data type.

entity-framework sql-server

Question

I know there are a ton of posts about this issue but none of them seem to solve my problem.

Here's the scenario:

I have a CreateDate DateTime column in my MS SQL Server database User table that is non-nullable and is automatically set using GetDate() method in "Default Value or Binding" setting.

I am able to create a User just fine with the standard EF Insert but when I try to update the user, I get this error:

The conversion of a datetime2 data type to a datetime data type resulted in an out-of-range value.

What is the trick to not having the EF worry about the CreateDate column for updates? I have the StoreGenerationPattern = Identity but that isn't helping.

Here are the EF properties for my Entity Property: http://screencast.com/t/8ndQRn9N

And here is my Update method: http://screencast.com/t/UXIzhkhR

1
2
3/20/2011 12:07:38 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

Have you tried setting the StoreGeneratedPattern attribute to 'Computed'. Failing that, as a last resort, try changing the column's datatype to datetime2.

[The problem arises because the .NET DateTime.MinValue equals 0001-1-1 but Sql Server DateTime covers 1753-1-1 through 9999-12-31]

4
3/20/2011 12:48:40 AM

Related Questions

LINQ to Entities only supports casting in the Entity Framework. basic kinds in the Entity Data Model

I know this is old, but I was looking to accomplish the exact same thing as the OP and didn't want to use the ...Func<IQueryable<T>, IOrderedQueryable<T>>... in my dictionary. Mostly because I would have to implement both an ...OrderBy... and ...OrderByDescending... delegate....I ended up creating an extension method for IQueryable called ...Object...
entity-framework primitive-types
asked by Lucifer Sam

When converting a datetime2 data type to a datetime data type, an out-of-range value is returned.

This can happen if you do not assign a value to a ...DateTime... field when the field does not accept ...NULL... values. ...That fixed it for me!
c# datetime entity-framework orm sql-server
asked by andyuk

When converting a datetime2 data type to a datetime data type, an out-of-range value was returned.

For me, I had the same issue, but the problem was that by default when I saved my Model, an invalid DateTime was being created. I had a field CreatedOn and had not set it to anything, which meant the value was 01/01/0001 which was an invalid DateTime for SQL. Setting it got rid of the problem for me.
asp.net-mvc datetime entity-framework
asked by Colin Asquith

How to Repair "SqlException: A datetime2 data type was converted to a datetime data type with an out-of-range value."

I had the same exception, but it was because a non nullable datetime property that taking the min datetime value. That wasn't a smalldatetime at DB, but the min datetime of C# exceed the limit of min datetime of SQL. The solution was obvious, set the datetime properly. BTW, the code wasn't mine, and that's why I wasn't aware of that property :)
asp.net c# entity-framework webforms
asked by Milton

The conversion of a datetime2 data type to a datetime data type Error

I had the same problem when I tried to save an unassigened DateTime member to the DB, while using EntityFramework. I read the answers here, and I learned that it can be solved by declaring the member as nullable. I tried it, and it worked! So here is a code snap, for those who need it:...public Nullable<DateTime> MyDateTime { get; set; } ...or...pu...
asp.net-mvc c# datetime entity-framework
asked by Asaf

Entity Framework Cannot Save - Conversion Of Datetime2 To DateTime Failing

Julie Lerhman discusses this exact issue here (...http://channel9.msdn.com/Shows/Visual-Studio-Toolbox/Entity-Framework-Tips-and-Tricks...), and trust me, she is the expert....Myself, I'd make [NoteDateTime] nullable in your code like so...public DateTime? NoteDateTime { set; get; }
asp.net asp.net-mvc c# entity-framework sql
asked by AFD

"Unknown data type" error with Firebird embedded and Entity Framework 6

I Had the same problem, The Entity initializer is bugged with Firebird embedded: ...Database.SetInitializer<FirebirdDbContext>(new CreateDatabaseIfNotExists<FirebirdDbContext>()); ...is the problem, change it to:...Database.SetInitializer<FirebirdDbContext>(null); ...But it will not create the database for you. You could check if the database file...
c# ef-code-first entity-framework-6 firebird firebird-embedded
asked by Leonardo Xavier

Entity Framework with SQLite Error: An error occurred while reading from the store provider's data reader

I had this error occur in EF6.1 and took me a while to figure out what was going on. Simplified the query, and it worked, so I figured something must be going on in the query. Found out I was querying a string and passing a compare on an int. once I changed the int.toString all worked....Dim OpenOrder = (From p In context.CP_Carthead Where p.Sessi...
.net-4.5 c# entity-framework sqlite wpf
asked by ransems

Cannot implicitly convert type System.Data.Entity.Core.Objects.ObjectResult to System.Data.Objects.ObjectResult

I had the error and none of these solutions worked (I was already using ...System.Data.Entity.Core.Objects..., it was also in the ...context.tt..., etc)....I eventually realised the problem lay between the keyboard and the chair. The stored proc finished with a select, but I was trying:...MyStoredProc_Result r = dbcontext.MyStoredPoc(); ...Instead ...
c# entity-framework
asked by SteveCav

conversion of a datetime2 data type to a smalldatetime EF6 MVC5

The minimum value for smalldatetime is ...1900-01-01...The minimum value for datetime2 is ...0000-01-01...Presumably, what is happening here is that we are passing a datetime2 value into a smalldatetime column. When datetime2 not been supplied and it is NON NULL then it will default to it's minimum value of ...0000-01-01.... This is well below t...
asp.net-mvc-5 entity-framework-6 sql type-conversion
asked by Troy Witthoeft

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