Hi,

I need to execute a query in my native SQL dialect as I need to use a slightly unusual locking hint. I need to lock the selected row for update and also read past any other row that is already locked for update. This way I can have multiple machines attempting to request the first item from the queue without any machine getting the same record as another.

In standard MS SQL I would do it like this (this has been somewhat simplified, but it would run in a transaction):



Is there a way to do this from an NHibernate session? Or do I need to manually use the underlying connection to manage this?

Cheers,

Symon.

Just use the underlying connection I would say... There's no benefit to using NHibernate in this case.

No problem. I was just wondering whether if I used NHibernate for it then it would control the opening/closing of the connection and the transaction (if one were present).

I'm assuming that the connection for the session will be closed and there won't be a db transaction present unless I'm in the middle of an NHibernate transaction...is that right?

Cheers,

Symon.