EF Core Transactions Example

Database transaction is used to process multiple actions in an atomic manner (ACID). In Entity Framework or EF Core, SaveChangeswill perform all changes in one transaction if the database supports that. You can also use DbContext.Database.BeginTransaction method to initiate a transaction.

Code snippet

The following code snippet creates a customer and account in one transaction. If the account creation fails, the transaction will be rolled back automatically. There is no explicit transaction rollback as it uses usingstatement which will dispose the transaction object.

using var context = new ApplicationDbContext();
using var transaction = context.Database.BeginTransaction();

try
{
var customer = new Customer(Name="A Customer");
context.Customers.Add(customer);
        await context.SaveChangesAsync();

var account = new Account(OpenDate = DateTime.Now, CustomerID = customer.ID);
context.Accounts.Add(account);
await context.SaveChangesAsync();

        transaction.Commit();
}
catch (Exception)
{
}