EntityFramework and TransactionScope Inconsistency

Question

I am developing a component where I am using Entity Framework 4.0.

In a particular scenario I need to make use of a TransactionScope.

try
{
    using (TransactionScope t = new TransactionScope())
    {
        myEntity.MyObjectsOne.Add(new MyObjectOne());
        myEntity.MyObjectsTwo.Add(new MyObjectTwo());

        myEntity.SaveChanges();

        throw new Exception();

        t.Complete();
    }
}
catch (Exception e)
{
    // What should I do?
}

When the transaction fails and thus it is not completed, myEntity will still reflect the changes made i.e. the adding of MyObjectOne and MyObjectTwo.

In such case what is the best practice, in order to avoid inconsistency?

The same instance of the context will still be used after that process. — JEPAAB, Feb 12 '15 at 15:05

score 5 · Answer 1 · edited May 23 '17 at 11:49

5

The usual way to do what you need to do is to dispose and reload your entity from fresh in the catch block, so that unless the scope is properly committed, your entity gets reloaded as it was before any change was applied to it.

see this question and all answers for more details: Undo changes in entity framework entities

edited May 23 '17 at 11:49

Community

1
1

answered Feb 12 '15 at 15:05

Davide Piras

43,984
10
98
147

EntityFramework and TransactionScope Inconsistency

1 Answers1