I have a table in which i want to do an update to. I just dont know how to do it with nhibernate.

For eg, I have a customer table, one of the fields is name and I want to simply use the customer id, which I have on hand to simply change the name if I wanted to. The sql could be something like

Update customer set name = "Joe Bloe" where customer_id = 23

But how do you do such a simple thing with nHibernate. Do I have to use HQL? Can someone give me a clue.

Thanks

This is not possible with NHibernate; a session can only save loaded entities.

You may either load the entity first or use classic SQL (not recommended if the operation is not performance-critical...)

The problem is that all of this occurs in a transaction and i need to get the returned id from one insert before I insert another. What I do i go back to the table that I passed by and update it with the id after its already been inserted. How could i do this with nihibernate then.

Can you post your code? (between OpenSession() and session.Close())

I removed the problem by really learning how to use nHibernate the way it was meant to be used, but thanks anyway.