title: Storing TimeSpan with Entity Framework Codefirst - SqlDbType.Time overflow
body: <p>I'm trying to seed some constants into my DB: </p>
  
  <pre><code>context.Stages.AddOrUpdate(s =&gt; s.Name,
                                     new Stage()
                                     {
                                         Name = "Seven",
                                         Span = new TimeSpan(2, 0, 0),
                                         StageId = 7
                                     });
  context.Stages.AddOrUpdate(s =&gt; s.Name,
                                     new Stage()
                                     {
                                         Name = "Eight",
                                         Span = new TimeSpan(1, 0, 0, 0),
                                         StageId = 8
                                     });
  </code></pre>
  
  <p>This is within my Seed() function for EF Codefirst Migrations.  It fails at Stage Eight with the following: </p>
  
  <blockquote>
    <p>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.</p>
  </blockquote>
  
  <p>Why would I not be able to store a timespan using EF?  I really hope I don't need to do some silly time-to-ticks conversion on both ends here... </p>