ActiveRecord: How do I add NOLOCK?

Question

I need to add "WITH NOLOCK" when using ActiveRecord? I know there is a way to do it nHibernate, but couldn't figure this out in ActiveRecord.

Thank you for your help. Regards,

Answer 1

Not to revive an old post. But there is an option to lock per query rather than setting it in the model.

For Example:

Account.where("name = 'shugo'").lock(true).first

Check out this link for more info. http://api.rubyonrails.org/classes/ActiveRecord/Locking/Pessimistic.html

Answer 2

I know this is old, but here is the answer:

criteria.SetLockMode(NHibernate.LockMode.None);