Update one column on a table

thilak · **Joined:** Wed Jul 15, 2009 2:24 am **Posts:** 2

Let's say I have a model such as:

Code:

public class Person
{
      public virtual int Id { get; set; }
      public virtual string FirstName { get; set; }
      public virtual string LastName { get; set; }
      public virtual bool Active { get; set; }
}

... and of course the appropriate hbm mapping.

Is there a way for me to get NHibernate to do an update to the database... but only on a single column... for example the Active column?

i.e. SQL...

Code:

UPDATE [Person]
SET [Active] = @Active
WHERE [Id] = @Id

wolli · **Posted:** Wed Jul 15, 2009 6:38 am

Put update="false" in the property mapping.

http://nhforge.org/doc/nh/en/index.html#mapping-declaration-property

thilak · **Joined:** Wed Jul 15, 2009 2:24 am **Posts:** 2

Yup, that could be done... however, I'd like to be able to update all the fields in the "normal" update process.... however deletes, which I'd like to treat as a soft delete, I was wondering if there's some way for me to do just an update on the Active column only.