I want to use sql query to update couple of columns in a table.
I am using native query to do it.

My sample query looks like this.

ISQLQuery query = session.CreateSQLQuery("Update VcsSpm_SupplierMstr set SupplierStatus = 'F' where SupplierCode = 'S001'");

When executing this query i am getting the below exception.

"Return types of SQL query were not specified"

Any help in this regard is appreciated.

Thanks

NHibernate does not support update queries in CreateSQLQuery. Execute the query using the ADO.NET API.

Append something like "Select @@rowCount as noOfRowsAfftected" to your query and this will probably work.

However, this may not be a recommended approach.

Regards,
Indrajeet

What is the approach i need to take if i want to do partial update in a table using NHibernate.
If my requirement is that i need to update only status column in a particular table, is it possible using NHibernate APIs???

I could not come across any approach using nHibernate APIs.

I am aware of only one approach(workaround) which we have already discussed here...
Through ISQLQuery interface as you have done in your first post. You will need to append the Select query to it (as I mentioned in my previous post).


Regards,
Indrajeet

Actually with a little creativity this can be made to work:

Note that technique that I suggested above does not work with all databases. It does work with SQL Server but it did not work for SQL Anywhere 10 (I wrote a custom Driver - I'll contribute it to the project). The workaround was to use a combination of my approach and the suggestion made by IndrajeetP:


Of course it would be wonderful if ISQLQuery contained an Execute() / NoResult() method. If other people think that this would be useful then I can look into adding this.

Hi, I m trying to execute Select statment like
ISQLQuery sql = _session.CreateSQLQuery("select count(*) from PD4Log");
sql.AddScalar("xyz", NHibernateUtil.Int32);

string _results = sql.SetFirstResult(0).UniqueResult().ToString();

and it show the following error
System.IndexOutOfRangeException
Please reply how to execute any select stament and get the result in Nhibernate.
Thanks
Mukesh
mukesh.usts@gmail.com

I believe that you are trying to return a row count which is a different to what I was trying to illustrate above. Nevertheless this is how I would do this: