I am writing this code And it keeps throwing the error that SqlDate should be between (SomeDate) and (SomeDate). whats happenning ??

Configuration cfg = new Configuration();
cfg.AddAssembly("WebApplication1");
ISessionFactory factory = cfg.BuildSessionFactory();
ISession session = factory.OpenSession();
ITransaction transaction = session.BeginTransaction();

IList personList = session.CreateCriteria(typeof(Person)).List();

foreach(Person person in personList)
{
if(person.Name.Equals("Azam"))
{
DateTime time = DateTime.Now;
person.DateStarted = DateTime.Now;
session.Save(person);
transaction.Commit();
break;
}
else
{ Response.Write("Azam is not in the list"); }
}

could be any number of things. can you post the specific error from the log4net log? also, might be good to include the INSERT statement being generated by NH.

-devon