Batching DB commands in Entity Framework 4.0

by

No, it can’t be done (yes – i weep also).

EF does not support batch operations, LINQ-SQL had (has) the same problem.

You’ve got a few options:

  1. Stored Procedures
  2. Classic ADO.NET or EntitySQL
  3. Triggers

I’ve gone with option 1 and 3 in the past.

The problem with all three approaches is you lose the EF abstraction, the internal graph (optimistic concurrency), and your brought back to the world of native SQL.

More Related Contents:

  1. Introducing FOREIGN KEY constraint may cause cycles or multiple cascade paths – why?
  2. How to make Entity Framework Data Context Readonly
  3. How to set default value for POCO’s in EF CF?
  4. Entity Framework 4 Single() vs First() vs FirstOrDefault()
  5. Entity Framework and Connection Pooling
  6. Entity Framework vs LINQ to SQL
  7. Like Operator in Entity Framework?
  8. Fake DbContext of Entity Framework 4.1 to Test
  9. Entity Framework: table without primary key
  10. How do I enable EF migrations for multiple contexts to separate databases?
  11. Using Entity Framework (code first) migrations in production
  12. Does Entity Framework support parallel async queries? [duplicate]
  13. Is is possible to check if an object is already attached to a data context in Entity Framework?
  14. The repository itself is not usually tested?
  15. What are Navigation Properties in Entity Framework for?
  16. LINQ to Entities does not recognize the method Int32 get_Item(Int32)
  17. How to map table splitting in EF Code First?
  18. Start a Task in the Form Shown event
  19. Organizationally, where should I put common queries when using Entity Framework Code First?
  20. Entity Framework is Too Slow. What are my options? [closed]
  21. Using entity framework on multiple databases
  22. entity framework Unable to load the specified metadata resource [duplicate]
  23. How can I configure Entity Framework to automatically trim values retrieved for specific columns mapped to char(N) fields?
  24. How to store images using Entity Framework Code First CTP 5?
  25. Do you think it’s advantageous to switch to Entity Framework? [closed]
  26. Model First with DbContext, Fails to initialize new DataBase
  27. Validate data using DataAnnotations with WPF & Entity Framework?
  28. Getting exact error type in from DbValidationException
  29. Using Entity Framework entities as business objects?
  30. Entity framework 4.3 run migrations at application start

Leave a Comment