SQL DateTime Overflow when using DateTime.Now + LINQ to SQL

Question

Im getting a strange error when trying to add a new item to a table using LINQ

error : SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.

Code:

dbc.TblEvent newEvent = new dbc.TblEvent();
        newEvent.Subject = "Registered";
        newEvent.PersonID = PersonId;
        newEvent.EventDate = DateTime.Now;
        newEvent.EventTypeID = 23;
        newEvent.EventStatusID = 10;
        context.TblEvents.InsertOnSubmit(newEvent);

As you can see I'm not doing anything exciting. What can I do to sort this?

Andrey · Accepted Answer · 2010-10-12 13:22:24Z

5

99 out of 100 times a date time overflow in linq happens because the date is not being set. DateTime has a default value that is lower than the lowest date sql can handle.

Check all your assignments. Are you missing another date time field in your table?

answered Oct 12, 2010 at 13:22

Andrey

1,24712 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

DazManCat Over a year ago

Not that arnt nullable or are defaulted (DateEntered is set to getDate())

Andrey Over a year ago

Default is the problem. Linq will not respect the default by default and will instead assign an min datetime. Set the AutoGenerated property for the field in the linq designer to true

DazManCat Over a year ago

Ahhh yes spotted the problem. You were right there was a date field missing, even though it has a default in the DB it still complained.

user369142 · Accepted Answer · 2018-11-16 20:34:53Z

0

Another scenario for this: changed a query from a LEFT JOIN to an INNER JOIN, hence making a previously nullable datetime field, non-nullable. Needed to delete the table from the .dbml and re-add to get his to refresh the model.

answered Nov 16, 2018 at 20:34

user369142

2,9652 gold badges23 silver badges10 bronze badges

Collectives™ on Stack Overflow

SQL DateTime Overflow when using DateTime.Now + LINQ to SQL

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related