Services
Technology Web App Development Mobile App Development Windows App Development Database Development UI/UX Development Cloud Development SEO Digital Marketing Guest Posting Content Writing Artificial Intelligence Data Science ERP Development CRM Development CMS Development LMS Development Business Listing Blockchain Technology Startup Promotion AI Tools Integration
Products
Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller
Developer
Article Blog Forum Interview Beginner News Startup Quiz
Users
Career
Apply Job Internship
Pricing
Login Sign Up Get a Quote

interview

Home Interviews How does Entity Framework handle transactions? – MindStick
Ask Question

1 Answers

ICSM Computer
ICSM Computer 13 Jun 2025
Report Abuse

Entity Framework (EF) handles transactions to ensure that a group of database operations either all succeed or all fail — maintaining data integrity.

EF manages transactions automatically for simple scenarios, and also allows manual transaction handling for more complex use cases.

1. Automatic Transaction Handling

When you call SaveChanges(), EF wraps the changes in a transaction:

using (var context = new MyDbContext())
{
    context.Products.Add(new Product { Name = "Phone" });
    context.SaveChanges(); // Wrapped in a transaction automatically
}

If something fails during SaveChanges(), EF will roll back the transaction.

2. Explicit Transactions with DbContextTransaction

For multiple operations where you want atomicity, you can use:

using (var context = new MyDbContext())
{
    using (var dbContextTransaction = context.Database.BeginTransaction())
    {
        try
        {
            context.Products.Add(new Product { Name = "Tablet" });
            context.SaveChanges();

            context.Customers.Add(new Customer { Name = "Anna" });
            context.SaveChanges();

            dbContextTransaction.Commit();
        }
        catch
        {
            dbContextTransaction.Rollback(); // Rollback all changes
        }
    }
}

3. Using TransactionScope (System.Transactions)

Useful when:

  • You want to include multiple DbContexts
  • Or combine EF with ADO.NET/manual DB calls
using (var scope = new TransactionScope())
{
    using (var context = new MyDbContext())
    {
        context.Orders.Add(new Order { Total = 500 });
        context.SaveChanges();
    }

    using (var anotherContext = new AnotherDbContext())
    {
        anotherContext.Logs.Add(new Log { Message = "Order placed" });
        anotherContext.SaveChanges();
    }

    scope.Complete(); // Commits both contexts
}

TransactionScope may escalate to a distributed transaction depending on database configuration (e.g., MSDTC required).

4. Asynchronous Transaction Handling (EF6+)

using (var context = new MyDbContext())
{
    using (var transaction = context.Database.BeginTransaction())
    {
        try
        {
            context.Users.Add(new User { Name = "Alice" });
            await context.SaveChangesAsync();

            context.Logs.Add(new Log { Message = "User added" });
            await context.SaveChangesAsync();

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

Summary

Use Case Method
Single SaveChanges() call Auto transaction (default behavior)
Multiple DB operations BeginTransaction(), Commit(), Rollback()
Multiple DbContext or external ops TransactionScope (System.Transactions)
Async-safe transaction Use await + BeginTransaction()
MindStick Training
Markdown for AI

A clean, structured version of this page for AI assistants and LLMs.

Open .md