Is there a way to get NHibernate to emit a dead end hint?

Question

Is there a way to get NHibernate to emit a dead end hint? for example, for the SQL server "SET DEADLOCK_PRIORITY LOW". At the moment, I am just executing a raw SQL query.

Answer 1

I am sure there is no such thing. And emitting raw SQL seems to me in this very specific case.

Answer 2

Here is a technique to set lock lock priority , nhibernate hooks are used to emit a deadlock priority

: , ​​ -.

Answer 3

I used the interceptor and comment based method to add the query hint to the HQL or ICriteria query, you can find the information here . This is not a real solution for you, but you can start here and modify the interceptor to give a hint of a dead end.