NHibernate generates update statement for all columns

Question

Does NHibernate always generate update for all columns?

public class Person
{
    public virtual int Id { get; set; }
    public virtual string Name { get; set; }
    public virtual string Address { get; set; }
}

Person p = Session.Load(1);
p.Name = "New Name";

Session.Flush();//Update for all columns, but I change only Name

Is it normal behavior for NHibernate or my mistake? I use Fluent NHibernate and AutoMapping.

Andy, if some of your other questions have known a solution from other's answer, please accept them so that it may help others who shall have the same question as yours. — Will Marcouiller

Diego Mijelshon Diego Mijelshon · Accepted Answer · 2010-12-16T21:46:26

That is the default behavior, but you can make NH update modified columns only by adding dynamic-update="true" to your <class> mapping.

NHibernate generates update statement for all columns

2 Answers