Storing TimeSpan with Entity Framework Codefirst - SqlDbType.Time overflow

.net c# ef-code-first entity-framework

Question

I'm attempting to seed my database with some constants:

context.Stages.AddOrUpdate(s => s.Name,
                                   new Stage()
                                   {
                                       Name = "Seven",
                                       Span = new TimeSpan(2, 0, 0),
                                       StageId = 7
                                   });
context.Stages.AddOrUpdate(s => s.Name,
                                   new Stage()
                                   {
                                       Name = "Eight",
                                       Span = new TimeSpan(1, 0, 0, 0),
                                       StageId = 8
                                   });

In my Seed() function for EF Codefirst Migrations, this is contained. Stage Eight is where it fails due to the following:

System.Data.UpdateException: An error occurred while updating the entries. See the inner exception for details. ---> System.OverflowException: SqlDbType.Time overflow. Value '1.00:00:00' is out of range. Must be between 00:00:00.0000000 and 23:59:59.9999999.

Why wouldn't EF allow me to store a timespan? I sincerely hope that I won't need to perform any ridiculous time-to-ticks conversions on either end of this.

1
26
6/16/2013 3:03:24 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

This sentence:

Span = new TimeSpan(1, 0, 0, 0)

Use of this constructor by you

public TimeSpan(int days, int hours, int minutes, int seconds);

In other words, you're developing aTimeSpan more than 24 hours have passed since your passing1 to thedays however your underlying Database type is parameterTime which only allows inputs in the range 00:00-23:59.

It's difficult to know if you intended to have aTimeSpan or it's just a misprint, with 1 day.

If you truly desire aTimeSpan if your field's value is more than 24 hours, I assume you'll need to map it to another Database type (suchSmallDateTime ).

To fix a simple typo, simply replace your line to:

Span = new TimeSpan(1, 0, 0),
7
6/16/2013 7:51:20 AM

Popular Answer

    [Browsable(false)]
    [EditorBrowsable(EditorBrowsableState.Never)]
    [Obsolete("Property '" + nameof(Duration) + "' should be used instead.")]        
    public long DurationTicks { get; set; }

    [NotMapped]
    public TimeSpan Duration
    {
#pragma warning disable 618
      get { return new TimeSpan(DurationTicks); }
      set { DurationTicks = value.Ticks; }
#pragma warning restore 618
    }

Update

Since the release of EF Core 2.1, this is now possible using Currency Conversion.

builder.Entity<Stage>()
    .Property(s => s.Span)
    .HasConversion(new TimeSpanToTicksConverter()); // or TimeSpanToStringConverter
Shimmy

Related Questions

When using Entity Framework and LINQ to query huge databases, how can you prevent memory overflow?

Working with huge datasets in Entity Framework correctly involves:...Use POCO objects and EFv4 to share objects with higher layers without creating an Entity Framework dependency....To entirely separate POCO entities from object context, disable proxy construction and lazy loading....Expose ...IQueryable<EntityType>... to enable the higher layer to...
c# entity-framework linq
asked by Ladislav Mrnka

In Entity Framework 4.1, you may update a reference to a child object (CodeFirst)

The state being set to...Modified... modifies just your navigation properties, not scalar or complex ones. Only Entity Framework's change detection is used for this. The original must be retrieved from the database, which means:...using (var context = new JobContext()) { var originalJob = context.Jobs.Include(j => j.JobType) .Single(j =...
c# code-first ef-code-first entity-framework
asked by Slauma

Entity Framework TimeSpan - Time Error

Your SQLServer version can help to clarify your problem....Support for Entity Framework 5 zzz-9 zzz...TimeSpan... It utilizes...time... is the backup type for SQL. Support for the...time... with the release of SQL Server 2008. Is it conceivable that you changed from an instance of SQL Server 2005 to one from 2008 or later? That would cause everythi...
c# entity-framework service
asked by joelmdev

Entity Framework 4 Stored Procedure Call Timing Out

I recently encountered a problem that was very similar, and one of our DBAs presented it to me as follows (paraphrased and simplified, of course):...An execution plan for stored procedure ...per ...object_id... is created and cached by the server when a SQL Server stored procedure is called. Depending on the value of the parameter that is passed in...
.net entity-framework sql-server-2008-r2
asked by alimbada

Object Mapping from stored procedure using the columnname attribute in EntityFramework CodeFirst

Column attribute is not honored by SqlQuery. If the column names in the provided result set correspond to the names of the entity's properties, the properties should be set appropriately. However, keep in mind that SqlQuery only performs a small amount of work (for example, it does not support relationships (.Include)), so if you choose to use stor...
columnattribute ef-code-first entity-framework-6
asked by Pawel

How to set the isolation level for Entity Framework CodeFirst Migrations

In your migration code, SQL can be written and executed:...Dynamic SQL was used prior to SQL Server 2012:...public override void Up() { Sql("DECLARE @SQL NVARCHAR(4000) = 'ALTER DATABASE '+ DB_NAME() +' SET ALLOW_SNAPSHOT_ISOLATION ON' ; EXEC sp_executeSql @SQL;", true); } ...When using SQL Server 2012 or later,...public override void Up() { ...
c# ef-migrations entity-framework entity-framework-6 sql-server
asked by Major

Entity Framework Stored Procedures - Multiple Result sets with CodeFirst

ZZZ_tmp
asp.net-mvc c# entity-framework
asked by Waleed A.K.

how to insert null Datetime in database with entity framework codefirst

EF inserts the usual 00/00/0001 date instead of null...There's ...usual... nothing about it. EF 6.1 inserts when left to its own devices....NULL... ....namespace ConsoleApplication1 { class Program { static void Main(string[] args) { var DataContext = new StackOverflowContext(); DateTime? date = null...
asp.net c# entity-framework
asked by ta.speot.is

Default physical location of Data base created in Entity Framework codefirst approach

Without a connection string specified and with a default instance of SQLServerExpress, the EntityFramework creates sql database files in your user folder (for example, C:Users[yourusername]) with the name assigned to your project....You can transfer these files at will because they don't seem to be connected to SQL Server.
c# datacontext entity-framework
asked by mattpm

How to edit 1000 records at time using entity framework in less time

ZZZ_tmp
asp.net asp.net-mvc c# entity-framework entity-framework-6
asked by planbsim

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