Hi,
I have a POCO with a "long" member mapped to a NUMERIC column of a table in the database. By default I get "0" inserted when I do an insert and not have a value specified for it. How can I get nhibernate to insert a NULL if it has no value instead of a 0?
Thanks,
Mel.



Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:

Mapping documents:

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

Name and version of the database you are using:

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:

Basically, is there an equivalent of Java's Long object in C# that a null can be assigned to so that I can get Nhibernate to insert a NULL into the database or is there some other convention that someone can enlighten me about?

You can use the Nullables library in contrib to support Null values.

That works or if you're using .Net 2.0 (VS2005), you can declare your object as Nullable<Long> and assign a null value to it. In your mapping file (or attributes) declare it as a Long.

Hi Folks,
Thanks for the replies, I don't use .NET 2.0, so I downloaded the Nullables package and it works.
Thanks.