NOLOCK with Linq to SQL

by

Yes it is, so here’s the entry from my blog:

The NOLOCK hint is essentially the
same as wrapping a query in a
transaction whose “isolation level” is
set to “read uncommitted”. It means
that the query doesn’t care if stuff
is in the process of being written to
the rows it’s reading from – it’ll
read that “dirty” data and return it
as part of the result set.

Turns out that you can do the whole
“read uncommitted” transaction thing
using the old System.Transactions
namespace introduced in .NET 2.0.
Here’s some sample code:

using (var txn = new TransactionScope(
    TransactionScopeOption.Required, 
    new TransactionOptions
    {
        IsolationLevel = IsolationLevel.ReadUncommitted
    }
))
{
    // Your LINQ to SQL query goes here
}

So I’m creating a new TransactionScope
object and telling it to use a
read-uncommitted isolation level. The
query within the “using” statement now
acts as if all its tables were reading
with the NOLOCK hint.

Here are the first results from a Google search for “linq sql nolock”:

InfoQ: Implementing NOLOCK with LINQ to SQL and LINQ to Entities

Matt Hamilton – LINQ to SQL and NOLOCK Hints : Mad Props!

Scott Hanselman’s Computer Zen – Getting LINQ to SQL and LINQ to …

More Related Contents:

  1. Is LINQ to SQL Dead or Alive?
  2. Does AutoMapper support Linq?
  3. How to do a join in linq to sql with method syntax?
  4. How do I update a Linq to SQL dbml file?
  5. Benchmark Linq2SQL, Subsonic2, Subsonic3 – Any other ideas to make them faster?
  6. ASP.MVC: Repository that reflects IQueryable but not Linq to SQL, DDD How To question
  7. Explicit construction of entity type ‘###’ in query is not allowed.
  8. Common Table Expression (CTE) in linq-to-sql?
  9. Convert SQL to LINQ to SQL
  10. C# Linq-to-Sql – Should DataContext be disposed using IDisposable
  11. T4 template to Generate Enums
  12. Using System.Data.Linq in a Razor view
  13. linq to sql: join multiple columns from the same table
  14. Difference Between Select and SelectMany
  15. LINQ to SQL Left Outer Join
  16. How to store a list in a column of a database table
  17. Linq – left join on multiple (OR) conditions
  18. LINQ to SQL and a running total on ordered results
  19. How to return anonymous type from c# method that uses LINQ to SQL [duplicate]
  20. Learning about LINQ [closed]
  21. Updating an ObservableCollection in a separate thread
  22. Convert Linq Query Result to Dictionary
  23. Persist Data by Programming Against Interface
  24. How to make LINQ execute a (SQL) LIKE range search
  25. Best Practice: Convert LINQ Query result to a DataTable without looping
  26. Best way to update LINQ to SQL classes after database schema change
  27. Multiple/single instance of Linq to SQL DataContext
  28. Is it possible to use SqlGeography with Linq to Sql?
  29. Do you think it’s advantageous to switch to Entity Framework? [closed]
  30. Linq to SQL: How do I stop the auto generated object name from being renamed?

Leave a Comment