how to run update HQL query in nHibernate ?

Question

I could not find any query.executeUpdate() method in IQuery interface or ISession where i can pass an hql to update a record.

here is the hql:

string hql = "update QAD qa set qa.NFS=:NFS where qa.ID = 1145";
IQuery q = session.CreateQuery(hql).SetString("NFS", "10");

Answer 1

What version are you using? I know it is in 2.1 at least..

Answer 2

I don't think that HQL is meant to support update operations .... When using an O/R mapper, all updates / inserts go through your object - model...
(Even if it is possible to update via HQL, I think (N)Hibernate will retrieve all the objects, modify them, and then save them back to the DB.
In this way , offcourse you loose performance since all objects need to be retrieved).

There also exists a feature request for it; and someone has implemented it, so maybe in a next version ? click

Answer 3

In NHibernate we are doing it a little bit different: you get the structure from the database, change the value and then commit the changes. I don't think it is possible to do this more directly...

//Pseudocode
T t = session.Get<T>(id);
t.NFS = 10;
session.SaveOrUpdate(t);
session.Transaction.Commit();