Why is inserting entities in EF 4.1 so slow compared to ObjectContext?

by

As already indicated by Ladislav in the comment, you need to disable automatic change detection to improve performance:

context.Configuration.AutoDetectChangesEnabled = false;

This change detection is enabled by default in the DbContext API.

The reason why DbContext behaves so different from the ObjectContext API is that many more functions of the DbContext API will call DetectChanges internally than functions of the ObjectContext API when automatic change detection is enabled.

Here you can find a list of those functions which call DetectChanges by default. They are:

  • The Add, Attach, Find, Local, or Remove members on DbSet
  • The GetValidationErrors, Entry, or SaveChanges members on DbContext
  • The Entries method on DbChangeTracker

Especially Add calls DetectChanges which is responsible for the poor performance you experienced.

I contrast to this the ObjectContext API calls DetectChanges only automatically in SaveChanges but not in AddObject and the other corresponding methods mentioned above. That’s the reason why the default performance of ObjectContext is faster.

Why did they introduce this default automatic change detection in DbContext in so many functions? I am not sure, but it seems that disabling it and calling DetectChanges manually at the proper points is considered as advanced and can easily introduce subtle bugs into your application so use [it] with care.

More Related Contents:

  1. Validation failed for one or more entities. See ‘EntityValidationErrors’ property for more details [duplicate]
  2. Entity Framework Code First – two Foreign Keys from same table
  3. Ignoring a class property in Entity Framework 4.1 Code First
  4. Entity Framework Join 3 Tables
  5. Why is .Contains slow? Most efficient way to get multiple entities by primary key?
  6. EF Code First: How to get random rows
  7. Navigation Property without Declaring Foreign Key
  8. Better way to query a page of data and get total count in entity framework 4.1?
  9. An error occurred while saving entities that do not expose foreign key properties for their relationships
  10. Can you get the DbContext from a DbSet?
  11. Entity Framework Code First Date field creation
  12. mapping multiple tables to a single entity class in entity framework
  13. Create association on non-primary key fields with Entity Framework 4.1 Fluent API
  14. Entity Framework Timeouts
  15. What difference does .AsNoTracking() make?
  16. What is the purpose of self tracking entities?
  17. LINQ to Entities does not recognize the method ‘Double Parse(System.String)’ method, and this method cannot be translated into a store expression
  18. Non-static method requires a target
  19. Using Asp.Net Identity DataBase first approach
  20. Fluent API, many-to-many in Entity Framework Core
  21. Entity Framework Code First Lazy Loading
  22. How to add the same column to all entities in EF Core?
  23. Dynamically changing schema in Entity Framework Core
  24. Enable-Migrations Exception calling “SetData” with “2” argument(s)
  25. Save detached entity in Entity Framework 6
  26. How do you check if a string contains any strings from a list in Entity Framework?
  27. How does the SQLite Entity Framework 6 provider handle Guids?
  28. How to set Identity Seed value in code-first?
  29. How to write this EF Mock setup code as a reusable Generic Boilerplate?
  30. .NET Managing Layers Relationships

Leave a Comment