I'm new to NHibernate, and I'm working on a simple 3-tier web application for tasks with the new ASP.NET MVC framework and a MS SQL 2005 database.

The only problem I'm running into is inserting a null date into the database because System.DateTime cannot be null. DateTime defaults to 1/1/0001 12:00:00 AM and MS SQL 2005 requires the date to be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. When I go to save a new task NHiberante attempts to insert the invalid date of 1/1/0001 12:00:00 AM to the database.

If anyone could enlighten me how to do this I would appreciate it.

Apparently my mind went completely blank when it comes to dealing with DateTimes in .NET. The solution is an easy one. The type of the attribute and property need to be DateTime? in my task class and it works fine.

Hi,
How are you handling RedirectToAction and NHibernate session. I loose session so lazyload does not work. Do you have Http module that opens session on each request?