EF Code First DBContext and Transactions

by
  1. Yes. SaveChanges uses transaction internally.
  2. Use TransactionScope to wrap multiple calls to SaveChanges

Example:

using(var scope = new TransactionScope(TransactionScopeOption.Required,
    new TransactionOptions { IsolationLevel = IsolationLevel.ReadCommitted }))
{
    // Do something 
    context.SaveChanges();
    // Do something else
    context.SaveChanges();

    scope.Complete();
}

More Related Contents:

  1. Code-first vs Model/Database-first [closed]
  2. Entity Framework: One Database, Multiple DbContexts. Is this a bad idea? [closed]
  3. The relationship could not be changed because one or more of the foreign-key properties is non-nullable
  4. Should I enable or disable dynamic proxies with entity framework 4.1 and MVC3?
  5. How do I detach objects in Entity Framework Code First?
  6. ADO.NET DbContext Generator vs. ADO.NET Poco Entity Generator (ObjectContext)
  7. How to include a child object’s child object in Entity Framework 5
  8. Order navigation properties when using Include and/or Select methods with EF 4.1 Code-First?
  9. Entity framework code-first null foreign key
  10. DbSet.Find method ridiculously slow compared to .SingleOrDefault on ID
  11. How do you ensure Cascade Delete is enabled on a table relationship in EF Code first?
  12. Ramifications of DbSet.Create versus new Entity()
  13. Entity Framework 4.1 default eager loading
  14. Entity Framework and calling context.dispose()
  15. How to pass parameters to the DbContext.Database.ExecuteSqlCommand method?
  16. Can you get the DbContext from a DbSet?
  17. How to update not every fields of an object using Entity Framework and EntityState.Modified
  18. Entity Framework Code First : Setting up One-To-One foreign key association using Annotations
  19. What is the best practice in EF Core for using parallel async calls with an Injected DbContext?
  20. EF 4.1 loading filtered child collections not working for many-to-many
  21. DbContext AutoDetectChangesEnabled set to false detecting changes
  22. Entity Framework Validation confusion – maximum string length of ‘128’
  23. Using the Entry().CurrentValues.SetValues() is not updating collections
  24. Entity Framework Code First Many to Many Setup For Existing Tables
  25. ASP.NET MVC 2.0 Implementation of searching in jqgrid
  26. Code First: Independent associations vs. Foreign key associations?
  27. Ignoring a class property in Entity Framework 4.1 Code First
  28. Entity Framework 6 Code first Default value
  29. EF Code First “Invalid column name ‘Discriminator'” but no inheritance
  30. Entity Framework Data Annotations Set StringLength VarChar

Leave a Comment