Thanks, Fabio! The AddLockHint will work just fine for my purposes. From: [email protected] [mailto:[email protected]] On Behalf Of Fabio Maulo Sent: Thursday, October 14, 2010 11:48 AM To: [email protected] Subject: Re: [nhusers] READPAST hint and HQL query?
Have a look to NHibernate.LockMode. If you are not using one of those values, as for example UpgradeNoWait or Force, you can override the dialect's method AppendLockHint to add "with (readpast)" On Thu, Oct 14, 2010 at 2:41 PM, Tyler Burd <[email protected]<mailto:[email protected]>> wrote: Hi all, I've got a query implemented in HQL. This query runs perfectly fine, but a new requirement has come up that we should use the (SQL Server-specific) READPAST hint on the query. Is this possible with NH and HQL, or do I have to convert the query to SQL and issue a SQL query? I'd prefer to not have to re-write the query, but I can't find anything obvious that allows me to add the READPAST hint... Thanks! Tyler Burd -- You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected]<mailto:[email protected]>. To unsubscribe from this group, send email to [email protected]<mailto:nhusers%[email protected]>. For more options, visit this group at http://groups.google.com/group/nhusers?hl=en. -- Fabio Maulo -- You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/nhusers?hl=en. -- You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/nhusers?hl=en.
