Fluent NHibernate SqlDateTime overflow exception
.net, c#, fluent-nhibernate, nhibernate, orm
Solution
Your entity should look like this:
public class User
{
public virtual DateTime? LastLoginDate {get;set;}
// etc
}
Then, your map should work properly.
edit: The `?` after DateTime specifies that it is Nullable, and is a short form for `Nullable<DateTime>`. If this isn't the cause of your error, you may want to check that Fluently.Configure specifies the correct version of SqlServer.
Problem
I'm mapping a very simple Users table, and i have a column named 'LastLoginDate' which is defined as nullable in sql server. My mapping looks like this : ``` public Users { Id(x => x.UserId); Map(x => x.UserName); ... ... Map(x => x.LastLoginDate).Nullable(); } ``` But everytime I try to save this entity programatically, i always get the SqlDateTime overflow exception. If i try to enter a manual sql statement with 'null' in this column it works. If i comment out just this property, it will work as well. What can be the problem ??? Thanks in advance!