Conversion of a datetime2 data type to a datetime data type results out-of-range value

c# sql-server entity-framework datetime orm
Gerbrand picture Gerbrand · Aug 26, 2009 · Viewed 376.6k times · Source

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 DateTime; that is wrong.

The date column is set to a DateTime like this:

new DataColumn("myDate", Type.GetType("System.DateTime"))

Question

Can this be solved in code or does something have to be changed on a database level?

Answer

andyuk picture andyuk · Nov 26, 2010

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!

Related questions

MSSQL Error 'The underlying provider failed on Open'

I was using an .mdf for connecting to a database and entityClient. Now I want to change the connection string so that there will be no .mdf file. Is the following connectionString correct? <connectionStrings> <!--<add …

Read More
Delete a single record from Entity Framework?

I have a SQL Server table in Entity Framework named employ with a single key column named ID. How do I delete a single record from the table using Entity Framework?

Read More
Entity Framework Migrations renaming tables and columns

I renamed a a couple entities and their navigation properties and generated a new Migration in EF 5. As is usual with renames in EF migrations, by default it was going to drop objects and recreate them. That isn't what I …

Read More