Entity Framework 6 transaction rollback

by

You don’t need to call Rollback manually because you are using the using statement.

DbContextTransaction.Dispose method will be called in the end of the using block. And it will automatically rollback the transaction if the transaction is not successfully committed (not called or encountered exceptions). Following is the source code of SqlInternalTransaction.Dispose method (DbContextTransaction.Dispose will finally delegate to it when using SqlServer provider):

private void Dispose(bool disposing)
{
    // ...
    if (disposing && this._innerConnection != null)
    {
        this._disposing = true;
        this.Rollback();
    }
}

You see, it checks if _innerConnection is not null, if not, rollback the transaction (if committed, _innerConnection will be null). Let’s see what Commit does:

internal void Commit() 
{
    // Ignore many details here...

    this._innerConnection.ExecuteTransaction(...);

    if (!this.IsZombied && !this._innerConnection.IsYukonOrNewer)
    {
        // Zombie() method will set _innerConnection to null
        this.Zombie();
    }
    else
    {
        this.ZombieParent();
    }

    // Ignore many details here...
}

internal void Zombie()
{
    this.ZombieParent();

    SqlInternalConnection innerConnection = this._innerConnection;

    // Set the _innerConnection to null
    this._innerConnection = null;

    if (innerConnection != null)
    {
        innerConnection.DisconnectTransaction(this);
    }
}

More Related Contents:

  1. Mapping composite keys using EF code first
  2. Database.BeginTransaction vs Transactions.TransactionScope [duplicate]
  3. Using Transactions or SaveChanges(false) and AcceptAllChanges()?
  4. SqlException from Entity Framework – New transaction is not allowed because there are other threads running in the session
  5. Conversion of a datetime2 data type to a datetime data type results out-of-range value
  6. Entity Framework Provider type could not be loaded?
  7. How to update record using Entity Framework 6?
  8. How to filter “Include” entities in entity framework?
  9. Writing Recursive CTE using Entity Framework Fluent syntax or Inline syntax
  10. Entity Framework 6 GUID as primary key: Cannot insert the value NULL into column ‘Id’, table ‘FileStore’; column does not allow nulls
  11. Setting unique Constraint with fluent API?
  12. Lazy Loading vs Eager Loading
  13. Entity Framework 6: audit/track changes
  14. Entity Framework 6 Code First Custom Functions
  15. EF 6 – How to correctly perform parallel queries
  16. DbSet.Attach(entity) vs DbContext.Entry(entity).State = EntityState.Modified
  17. Problems using Entity Framework 6 and SQLite
  18. Entity-framework code is slow when using Include() many times
  19. ‘datetime2’ error when using entity framework in VS 2010 .net 4.0
  20. Delete a single record from Entity Framework?
  21. Eager , Lazy and explicit loading in EF6
  22. Configure multiple database Entity Framework 6
  23. Entity Framework | Sequence contains more than one matching element
  24. Keyword Not Supported: Metadata
  25. Why is EF generating SQL queries with unnecessary null-checks?
  26. How to Identify the primary key duplication from a SQL Server 2008 error code?
  27. “The operation is not valid for the state of the transaction” error and transaction scope
  28. Should the order of LINQ query clauses affect Entity Framework performance?
  29. How does the SQLite Entity Framework 6 provider handle Guids?
  30. How can set a default value constraint with Entity Framework 6 Code First?

Leave a Comment