Using NOLOCK with Entity Framework

by Bar Zohan 16. June 2011 20:06

var transactionOptions = new System.Transactions.TransactionOptions();

transactionOptions.IsolationLevel = System.Transactions.IsolationLevel.ReadUncommitted;

using (var transactionScope = new System.Transactions.TransactionScope(System.Transactions.
TransactionScopeOption.Required, transactionOptions))
{
    using (var context = new MyEntityConnection())
    {
        //do nolocked ops here
    }
    transactionScope.Complete();
}

Tags: ,

.Net Framework | C# | SQL Server

Powered by BlogEngine.NET 1.5.0.7
Theme by Mads Kristensen

About the author

Page List