Entity Framework: TransactionScope has a different IsolationLevel

Question

I'm trying to use a TransactionScope at Domain level, so I can manipulate data across (potentially) several repositories, yet save all that in the same transaction.

I have the following save method:

public void Save(MyEntity source)
{
    using (var scope = new TransactionScope())
    {
        var context = new MyEFEntities(environment.ConnectionString);

        this.Repository.Add(source.ToDbMyEntity(), context);

        context.SaveChanges();

        scope.Complete();
    }
}

But I get the following error on the .SaveChanges():

The transaction specified for TransactionScope has a different IsolationLevel than the value requested for the scope. Parameter name: transactionOptions.IsolationLevel

What's causing this?

Can you let me know the current `Isolation Level` in your DB? http://stackoverflow.com/questions/1038113/how-to-find-current-transaction-level — Alireza, Nov 12 '15 at 14:47

score 4 · Accepted Answer · answered Nov 12 '15 at 14:48

I think that default isolation level for Entity framework is the one which is default for the database, for instance default isolation level of SqlServer is READ COMMITTED, while for TransactionScope default is Serializable so when you try to change it inside using (var scope = new TransactionScope()) block it throws an error. Try something like this:

var transactionOptions = new TransactionOptions();
transactionOptions.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted;
using (var scope = new TransactionScope(TransactionScopeOption.Required, transactionOptions));

Entity Framework: TransactionScope has a different IsolationLevel

1 Answers1