using (var context = new DbContext()) { using (var transaction = context.Database.BeginTransaction()) { var dbTransaction = transaction.GetDbTransaction(); // Perform some operations on the database using dbTransaction transaction.Commit(); } }
using (var context = new MyDbContext()) { using (var transaction = context.Database.BeginTransaction()) { try { // Perform some database operations here context.SaveChanges(); transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); } } }In this example, we wrap our database operations within a try-catch block to ensure that if an exception is thrown, we roll back the transaction to ensure data consistency. We use the BeginTransaction method to start a new transaction and the GetDbTransaction method to retrieve the underlying transaction object. We then use this transaction object to commit or roll back the transaction as needed. Package library: Microsoft.EntityFrameworkCore.