conversion of a datetime2 data type to a smalldatetime EF6 MVC5

asp.net-mvc-5 entity-framework-6 sql type-conversion

Question

I am using MVC5 with EF6 code first. I have a table with a Date(Datum) column in both tabels(Kommunication and Itemannounce) with smalldatetime type and when I try to set the date with System.DateTime.Now in the column I get the following error:

The conversion of a datetime2 data type to a smalldatetime data type resulted in an out-of-range value.The statement has been terminated.

I am aware of byte sizes and tried the following solution in my context:

  protected override void OnModelCreating( DbModelBuilder modelBuilder )
        {
        var annons = modelBuilder.Entity<Itemannounce> ( );
        annons.Property ( f => f.Datum ).HasColumnType ( "smalldatetime" );
        var komm = modelBuilder.Entity<Kommunication> ( );
        komm.Property ( f => f.Date ).HasColumnType ( "smalldatetime" );
        base.OnModelCreating ( modelBuilder );
        }

I still get same error. I tried to set the columns to NOT NULL without any luck. I am realy stuck in several days without to find a way out of this. Does anyone have a solution I have not tried?

1
0
5/13/2017 12:23:32 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

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 the floor for smalldatetime. It is out of bounds. Inserting a value outside of the range of smalldatetime would yield the error message you are recieving.

The conversion of a datetime2 data type to a smalldatetime data type resulted in an out-of-range value.The statement has been terminated.

There are many ways to solve this. I would suggest updating the model to use datetime2. 

 protected override void OnModelCreating( DbModelBuilder modelBuilder )
        {
        var annons = modelBuilder.Entity<Itemannounce> ( );
        annons.Property ( f => f.Datum ).HasColumnType ( "datetime2" );
        var komm = modelBuilder.Entity<Kommunication> ( );
        komm.Property ( f => f.Date ).HasColumnType ( "datetime2" );
        base.OnModelCreating ( modelBuilder );
        }

If you don't want to change the model then NULL checking could work as well. This similar question should give you a few ideas.

0
5/23/2017 11:47:23 AM

Related Questions

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

I've got a datatable with 5 columns, where a row is being filled with data then saved to the database via a transaction....While saving, an error is returned:...The conversion of a datetime2 data type to a datetime data type resulted in an out-of-range value...It implies, as read, that my datatable has a type of ...DateTime2... and my database a ..
c# datetime entity-framework orm sql-server
asked by Gerbrand

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

I have an ASP.NET MVC application where I am editing an existing database to update a paticular field, ...DateTime.... My database has 4 fields, two of which are ...DateCreated... and ...DateModified.... When I try to update the field, I want to keep ...DateCreated... time the same, no reason to update the date it was created, and I change the Date...
asp.net-mvc datetime entity-framework
asked by Anthony Forloney

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

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]
entity-framework sql-server
asked by Mitch Wheat

How can I use DbContext and SetInitializer to correct the datetime2 out-of-range conversion error?

I'm using the DbContext and Code First APIs introduced with Entity Framework 4.1....The ...data model... uses basic data types such as ...string... and ...DateTime.... The only data annotation I'm using in some cases is ...[Required]..., but that's not on any of the ...DateTime... properties. Example:...public virtual DateTime Start { get; set; } ....
.net c# dbcontext ef-code-first entity-framework
asked by Alex Angas

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

SqlException: The conversion of a datetime2 data type to a datetime data type resulted in an out-of-range value....my code is like this:... using (var contxt = new realtydbEntities()) { var status = GetStatus(); var repIssue = new RepairIssue() { CreaterId = AuthorId, ...
asp.net c# entity-framework webforms
asked by Scott 混合理论

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

I have a controller:...[HttpPost] public ActionResult Create(Auction auction) { var db = new EbuyDataContext(); db.Auctions.Add(auction); db.SaveChanges(); return View(auction); } ...A model:...public class Auction { public long Id { get; set; } public string Title { get; set; } public string Description { ge...
asp.net-mvc c# datetime entity-framework
asked by Alexandra Orlov

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

User in Entity type MVC5 EF6

I have created a class in MVC5, where I want a primary owner of the content and then I want to have some editors for the content:...public class Content { public int ID { get; set; } public IdentityUser Owner { get; set; } public ICollection<IdentityUser> Editors { get; set; } public string Title{ get; set; } public string Body ...
asp.net asp.net-identity asp.net-mvc-5 c# entity-framework
asked by Gunnar

EF6 Type of context 'System.Data.Entity.Core.Objects.ObjectContext' is not supported

I have a new project created using Visual Studio 2013 with an ADO.NET Entity Data Model (EF6)....Now I have to use some Dynamic Data function (like access to MetaTable object), so I add this code:...MetaModel model = new MetaModel(); model.RegisterContext(() => { return ((System.Data.Entity.Infrastructure.IObjectContextA...
asp.net c# entity-framework objectcontext
asked by gidanmx2

It is not possible to convert sql variant to varchar implicitly.

Dapper was internally mapping ...object... to ...sql_variant.... When I pass ...null... it was considering it as ...object... type. As my ...stored procedure... was expecting ...varchar..., ...sql_variant... was not convertible to it. ...I started passing ...string.Empty... instead of ...null... object and it was working fine....@Name = Request.Nam...
asp.net-core c# dapper entity-framework sql-server
asked by Kinjal Parmar

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