Is there any way to determine which column is causing the problem? Yes, I can manually look through the objects I'm trying to insert/update and check all the properties but I'm looking for a more robust solution. For example, SQL Server now returns the truncated column. Is there an equivalent for datetime
's?
SqlException: The conversion of a datetime2 data type to a datetime data type resulted in an out-of-range value. The statement has been terminated.
Yes, I'm sure I have a System.DateTime
this is System.DateTime.Minimum
and the column in SQL Server is defined as datetime
. I'm aware of the fix .