How to Bulk Update records in Entity Framework?

by

If you don’t want to use an SQL statement, you can use the Attach method in order to update an entity without having to load it first :

using (myDbEntities db = new myDbEntities())
{
    try
    {
      //disable detection of changes to improve performance
      db.Configuration.AutoDetectChangesEnabled = false;

      //for all the entities to update...
      MyObjectEntity entityToUpdate = new MyObjectEntity() {Id=123, Quantity=100};
      db.MyObjectEntity.Attach(entityToUpdate);

      //then perform the update
      db.SaveChanges();
    }
    finally
    {
      //re-enable detection of changes
      db.Configuration.AutoDetectChangesEnabled = true;
    }
}

More Related Contents:

  1. Linq: help me to make this work
  2. ‘Contains()’ workaround using Linq to Entities?
  3. How do I apply OrderBy on an IQueryable using a string column name within a generic extension method?
  4. How to use a string to create a EF order by expression?
  5. Writing Recursive CTE using Entity Framework Fluent syntax or Inline syntax
  6. The type of one of the expressions in the join clause is incorrect in Entity Framework
  7. LEFT JOIN in LINQ to entities?
  8. Linq to EntityFramework DateTime
  9. LINQ to SQL multiple tables left outer join
  10. Entity Framework (.NET Full Framework) Ordering Includes [duplicate]
  11. How to compare only date components from DateTime in EF?
  12. Entity Framework 6 Code First Custom Functions
  13. Entity Framework. Delete all rows in table
  14. “The LINQ expression node type ‘Invoke’ is not supported in LINQ to Entities” – stumped!
  15. LINQ to Entities does not recognize the method ‘System.Web.Mvc.FileResult’
  16. Order by dynamic parameter
  17. LINQ, Unable to create a constant value of type XXX. Only primitive types or enumeration types are supported in this context
  18. The operation cannot be completed because the DbContext has been disposed using MVC 4
  19. Dynamic table name in linq [duplicate]
  20. Linq Syntax – Selecting multiple columns
  21. Join and Include in Entity Framework
  22. Linq to Entity Join table with multiple OR conditions
  23. Creating dynamic queries with entity framework
  24. ‘Date’ is not supported in LINQ to Entities. Only initializers, entity members, and entity navigation properties are supported
  25. Log Queries executed by Entity Framework DbContext
  26. Max return value if empty query
  27. Remove item from list based on condition
  28. How to group by DateTime.Date in EntityFramework
  29. The LINQ expression node type ‘ArrayIndex’ is not supported in LINQ to Entities
  30. How to wrap Entity Framework to intercept the LINQ expression just before execution?

Leave a Comment