How to manually manage transactions?
Short answer: (BeginTransaction, Commit, Rollback) Use DbContext.Database.BeginTransaction() to start a transaction.
Explain a bit more
Call Commit() to save changes or Rollback() to undo. Useful for combining multiple operations that should succeed or fail as a unit. using var transaction = context.Database.BeginTransaction(); try { // Perform multiple operations context.SaveChanges(); transaction.Commit(); } catch { transaction.Rollback(); throw; }
Real-world example (ShopNest)
ShopNest’s order service uses EF Core to save an Order and its line items in one SaveChangesAsync() call inside a transaction.
Say this in the interview
- Define — one clear sentence (the short answer above).
- Example — relate it to a project like ShopNest or your real work.
- Trade-off — when you would not use it.
Share this Q&A
Share preview image: https://www.toolliyo.com/images/toolliyo-logo.png