How do add NOLOCK with nHibernate?

by

SetLockMode(LockMode.None) or connection.isolation ReadUncomitted does NOT append a NOLOCK to your queries.

Ayende goes into the correct answer on his blog:

If you’re using <sql-query> you can do the following:

<sql-query name="PeopleByName">
    <return alias="person"
                    class="Person"/>
    SELECT {person.*}
    FROM People {person} WITH(nolock)
    WHERE {person}.Name LIKE :name
</sql-query>

Note the WTIH(nolock) appended to the FROM clause.

More Related Contents:

  1. How do you map an enum as an int value with fluent NHibernate?
  2. IndexOutOfRangeException Deep in the bowels of NHibernate
  3. Unable to cast object of type NHibernate.Collection.Generic.PersistentGenericBag to List
  4. Binary Blob truncated to 8000 bytes – SQL Server 2008 / varbinary(max)
  5. NHibernate configuration for uni-directional one-to-many relation
  6. Generate XML mappings from fluent Nhibernate
  7. DateTime precision in NHibernate and support for DateTime2 in NHibernate SchemeExport
  8. Syntax to define a NHibernate Filter with Fluent Nhibernate?
  9. How to Eager Load Associations without duplication in NHibernate?
  10. Nhibernate: How to represent Many-To-Many relationships with One-to-Many relationships?
  11. What are the First and Second Level caches in (N)Hibernate?
  12. Fighting cartesian product (x-join) when using NHibernate 3.0.0
  13. What’s the difference between session.Merge and session.SaveOrUpdate?
  14. JSON.NET and nHibernate Lazy Loading of Collections
  15. List vs Set vs Bag in NHibernate
  16. How to tell Fluent NHibernate not to map a class property
  17. When to use inverse=false on NHibernate / Hibernate OneToMany relationships?
  18. nHibernate mapping to custom types
  19. How to create NHibernate HasManyToMany relation
  20. Is this the right way to eager load child collections in NHibernate
  21. NHibernate – CreateCriteria vs CreateAlias
  22. How to create OR statements for NHibernate?
  23. How to save a child with assigned id in nhibernate
  24. What is the difference between JoinQueryOver and JoinAlias?
  25. How do I view the SQL that is generated by nHibernate?
  26. Get Distinct result set from NHibernate using Criteria API?
  27. Why doesn’t Entity Framework support ODBC?
  28. NHibernate: difference between Interceptor and Listener
  29. What exactly is “persistence ignorance”?
  30. Programming to interfaces while mapping with Fluent NHibernate

Leave a Comment