Hi,

I need to update a customers balance relative to what it currently is, i.e. balance = balance + ordervalue (I don't want or care about concurrency checks).

I have placed the balance in a separate class and track the changes made to the balance so I know the relative difference (i.e. ordervalue). How do I get from there to executing sql like the following, or is there a another way?

update customer set balance = balance + 20 where ....

Cheers, Kerry

You can't do it in NHibernate without loading the customer first. Just use direct SQL.

I have the customer loaded as well, and the relationship between customer and balance is a one to one type relationship. Is there a way to do it now?

Am I able to attach a stored procedure within nhibernate to handle updates? Or is there some form of event I can subscribe to?

I ask because I will just have an ISession.Save(customer) type method which I want to handle the balance as well.

If you enable cascading to your balance, then Session.Save(customer) will save its balance also...

Cool.

Then to make the balance = balance + 20 type call, is it best to use interceptors, would that work or is there another technique?

Thanks