EF Core Transactions Example

Raymond Raymond event 2021-09-05 visibility 743
more_vert

Database transaction is used to process multiple actions in an atomic manner (ACID). In Entity Framework or EF Core, SaveChanges will 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 using statement 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)
{
}
More from Kontext
comment Comments
No comments yet.

Please log in or register to comment.

account_circle Log in person_add Register

Log in with external accounts