NoLock in Entity Framework

Question

NoLock in Entity Framework

asp.net-mvc-3 asp.net-mvc-4 c# c#-4.0 entity-framework-6

Question

I am trying to read the records from table even when the table is locked due to particular transaction.

I am using below code

public async Task<KeyValuePair<String, List<Om_Category>>> CategoryList(Om_Category obj)
{
    try
    {
        using (var transaction = new TransactionScope(
                TransactionScopeOption.Required,
                new TransactionOptions 
                { 
                    IsolationLevel = IsolationLevel.ReadUncommitted 
                },
                TransactionScopeAsyncFlowOption.Enabled))
        {
            using (var categoryContext = new ModelGeneration())
            {

                categoryContext.Configuration.ProxyCreationEnabled = false;
                var data = await categoryContext
                    .tblCategory
                    .ToListAsync();

                transaction.Complete();

                return new KeyValuePair<String, List<Om_Category>>("", data);
            }
        }
    }
    catch (Exception ex)
    {
        return new KeyValuePair<String, List<Om_Category>>(ex.Message, null);
    }
}

But seems like I am missing something to implement NoLocks. Still it show timeout. Am I missing something ?

Pankaj

View more on Stack Overflow

Pankaj · Accepted Answer · 9/30/2015 12:19:07 PM

Surprisingly Entity Framework inbuilt Transaction Class worked !!

public async Task<KeyValuePair<String, List<BE_Category>>> CategoryList(BE_Category obj)
{
    try
    {
        using (var categoryContext = new ModelGeneration())
        {
            using (var dbContextTransaction = categoryContext
                      .Database
                      .BeginTransaction(System.Data.IsolationLevel.ReadUncommitted))
            {
                categoryContext.Configuration.ProxyCreationEnabled = false;

                //Code

                dbContextTransaction.Commit();

                return new KeyValuePair<String, List<BE_Category>>("", data);
            }
        }
    }
    catch (Exception ex)
    {
        return new KeyValuePair<String, List<BE_Category>>(ex.Message, null);
    }
}

Reference

NoLock in Entity Framework

Question

Fastest Entity Framework Extensions

Accepted Answer

Performance

Expression Evaluator

Related