Answer
Use explicit transactions via:
await context.Database.BeginTransactionAsync();
Wrap operations in try/catch to commit or rollback.
Quick Answer
EF Core transactions: by default, SaveChangesAsync() wraps all changes in a transaction. Explicit transactions: using var tx = await context.Database.BeginTransactionAsync(); try { ... await context.SaveChangesAsync(); await tx.CommitAsync(); } catch { await tx.RollbackAsync(); }. Use explicit transactions when you need multiple SaveChanges or mix EF Core with raw SQL in one transaction.
S
SugharaIQ Editorial Team
Verified Answer
This answer has been peer-reviewed by industry experts holding senior engineering roles to ensure technical accuracy and relevance for modern interview standards.
Want to bookmark, take notes, or join discussions?
Sign in to access all features and personalize your learning experience.
Source: SugharaIQ