Entity Framework with NOLOCK

by

No, but you can start a transaction and set the isolation level to read uncommited. This essentially does the same as NOLOCK, but instead of doing it on a per table basis, it will do it for everything within the scope of the transaction.

If that sounds like what you want, here’s how you could go about doing it…

//declare the transaction options
var transactionOptions = new System.Transactions.TransactionOptions();
//set it to read uncommited
transactionOptions.IsolationLevel = System.Transactions.IsolationLevel.ReadUncommitted;
//create the transaction scope, passing our options in
using (var transactionScope = new System.Transactions.TransactionScope(
    System.Transactions.TransactionScopeOption.Required, 
    transactionOptions)
)

//declare our context
using (var context = new MyEntityConnection())
{
    //any reads we do here will also read uncomitted data
    //...
    //...
    //don't forget to complete the transaction scope
    transactionScope.Complete();
}

More Related Contents:

  1. MetadataException: Unable to load the specified metadata resource
  2. Encrypt password in App.config
  3. DbArithmeticExpression arguments must have a numeric common type
  4. ADO.Net Entity Framework An entity object cannot be referenced by multiple instances of IEntityChangeTracker
  5. Can you get the column names from a SqlDataReader?
  6. The type of one of the expressions in the join clause is incorrect in Entity Framework
  7. When using Trusted_Connection=true and SQL Server authentication, will this affect performance?
  8. How to create a DataTable in C# and how to add rows?
  9. ado.net Closing Connection when using “using” statement
  10. Using DataAnnotations with Entity Framework
  11. Entity Framework – retrieve ID before ‘SaveChanges’ inside a transaction
  12. Entity Framework with XML Files [closed]
  13. EF 6 – How to correctly perform parallel queries
  14. When should I create a new DbContext()
  15. EF 6 Parameter Sniffing
  16. The operation cannot be completed because the DbContext has been disposed error
  17. How to keep single SQL Server connection instance open for multiple request in C#?
  18. Database.BeginTransaction vs Transactions.TransactionScope [duplicate]
  19. How to use SqlCommand to CREATE DATABASE with parameterized db name?
  20. ExecuteNonQuery returning -1 when using sql COUNT despite the query string
  21. C# Entity-Framework: How can I combine a .Find and .Include on a Model Object?
  22. Entity framework: StoreGeneratedPattern=”Computed” property
  23. Why does the SqlParameter name/value constructor treat 0 as null?
  24. The relationship could not be changed because one or more of the foreign-key properties is non nullable
  25. C#, entity framework, auto increment
  26. Entity Framework not saving modified children
  27. How to wrap Entity Framework to intercept the LINQ expression just before execution?
  28. Change foreign key constraint naming convention
  29. Querying data using Entity Framework from dynamically created table
  30. Entity Framework Many to many through containing object

Leave a Comment