I've got a question about executing 'normal' SQL queries. In the project I'm working on I've got two kind of situations which are done in a qay, that is not using NHibernate. I would like to do this with NHibernate, but I'm not sure how to do this:

1) Execute an update statement without having to send the objects, so a query like this:

UPDATE table WHERE removed = 0

2) There are cases where an insert has to be made based on data from 3 different tables. Doing this in 1 query is way more efficient than doing it all in code en save those objects using NHibernate. This would be a query like:

INSERT INTO table(a,b,c)
SELECT .......

I hope these two cases are possible in NHibernate, so I can use NHibernate for all the functionality. I couldn't find it, maybe I looked wrong. It would be a big help if someone could tell me how to do this, or where to find how to do this.

I'm using the last version of NHibernate.

Thanks in advance for your help.
Koen Willemse

I think you are looking for this:

IDbConnection cn = session.Connection;

You now have a normal ADO.Net connection.



See also:

13.3. Custom SQL for create, update and delete

Being somewhat new to NH I've found that to ease the learning curve and still be productive I'm falling back to the IDbconnection with which I'm familiar. As I become more versant with NH coding I'll start using more of it's features.

Thank you, this was very helpfull, this was what I was looking for. Just one more thing. I see that you use the @ sign as the parametertoken. Is this token replaced for a token that the database accepts. I know that MySQL has a ? as parameter token. Does anybody know this?

Thank you very much.

In SQL Server, you can use 'named parameters', just like Richard12345 displays. :)