NHibernate - Setting Null Values (Insert and Update)

Lorelai · **Joined:** Sun Nov 05, 2006 10:19 am **Posts:** 13

I would like to know how I can send a database null value for a field from my code; is there anything such as obj.Field = DBNull.Value

Other suggestions are welcome

Thx in advance

gert · **Joined:** Thu Jan 19, 2006 4:29 pm **Posts:** 348

Lorelai wrote:

I would like to know how I can send a database null value for a field from my code; is there anything such as obj.Field = DBNull.Value

Other suggestions are welcome

Have You tried using nullables of net 2.0?

Gert

Longbow · **Joined:** Wed Jan 17, 2007 7:29 am **Posts:** 10

In case you don't know (took me a while to find out...) nullables are created by appending ? to the typename: int?, DateTime? etc. This only works in .Net 2.0.

If you're using .Net 1.1 you can use the Nullables.* library, it's included in the NHibernate SDK.

rafaelbelo · **Joined:** Mon Dec 11, 2006 12:35 pm **Posts:** 1

What I do is set the property of the object to null.

vb: obj.hisproperty = nothing
c#: obj.hisproperty = null

Now if it is a datetime type of property, then the only way to go is nullable.