The conversion of a datetime2 data type to a datetime data type resulted in an out-of-range value

Question

Assign datetime value in code in silverlight and save it to db by domainservice and EF: DateCreated = DateTime.Now

in database, the mapped column datetype is datetime, not datetime2.

then got following error: The conversion of a datetime2 data type to a datetime data type resulted in an out-of-range value.

How to fix it?

Possible duplicate of: The conversion of a datetime2 data type to a datetime data type resulted in an out-of-range value. — Joe Stefanelli
figure it out. becuase more than one item for DateTime. And some of them not set value(null). — KentZhou

Eric Eric · Accepted Answer · 2015-12-03T18:36:04

In your model put a questionmark behind the datatype.

public DateTime? myDate {get; set;}

This will allow NULL to be written in the database.