DB Date is null throwing a SqlDateTime overflow exception!

martbl · **Posted:** Fri Apr 13, 2007 5:01 pm

Hi,

When I try to read some rows from my database (SQL Server) .. and some rows contain null date field, I get the following error:

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

I understand the date being to null is not between the specified dates, but what can I do to avoid this?

Thanks

mnichols · **Joined:** Mon Aug 21, 2006 9:18 am **Posts:** 179

If you are using .NET 2.0 you can use the DateTime? (Nullable DateTime) type in your entities.
What I do is have a Specification that I initialize my entity values with

Code:

           public class DateTimeSpecification
    {
        public static DateTime UNSPECIFIED_MIN = new DateTime(1800,1,1).Date;
        public static DateTime UNSPECIFIED_MAX = new DateTime(2999,12,31).Date;
    }

Since DateTime is a valueobject (struct) those are the only options I have come up with when dealing with the disparity between SQL DateTime limits and .NET.

Hope this helps
MIKE