DbSet.Find method ridiculously slow compared to .SingleOrDefault on ID

by

Find calls DetectChanges internally, SingleOrDefault (or generally any query) doesn’t. DetectChanges is an expensive operation, so that’s the reason why Find is slower (but it might become faster if the entity is already loaded into the context because Find would not run a query but just return the loaded entity).

If you want to use Find for a lot of entities – in a loop for example – you can disable automatic change detection like so (can’t write it in VB, so a C# example):

try
{
    context.Configuration.AutoDetectChangesEnabled = false;
    foreach (var id in someIdCollection)
    {
        var competitor = context.Competitors.Find(id);
        // ...
    }
}
finally
{
    context.Configuration.AutoDetectChangesEnabled = true;
}

Now, Find won’t call DetectChanges with every call and it should be as fast as SingleOrDefault (and faster if the entity is already attached to the context).

Automatic change detection is a complex and somewhat mysterious subject. A great detailed discussion can be found in this four-part series:

(Link to part 1, the links to parts 2, 3 and 4 are at the beginning of that article)

http://blog.oneunicorn.com/2012/03/10/secrets-of-detectchanges-part-1-what-does-detectchanges-do/

More Related Contents:

  1. Entity Framework: One Database, Multiple DbContexts. Is this a bad idea? [closed]
  2. Code-first vs Model/Database-first [closed]
  3. Unique Key constraints for multiple columns in Entity Framework
  4. Entity Framework 6 Code first Default value
  5. The entity type is not part of the model for the current context
  6. EntityFramework code-first custom connection string and migrations
  7. EF Code First “Invalid column name ‘Discriminator'” but no inheritance
  8. Improve navigation property names when reverse engineering a database
  9. Should I enable or disable dynamic proxies with entity framework 4.1 and MVC3?
  10. How do I detach objects in Entity Framework Code First?
  11. EF5 Code First Enums and Lookup Tables
  12. Debug code-first Entity Framework migration codes
  13. Order navigation properties when using Include and/or Select methods with EF 4.1 Code-First?
  14. Entity Framework loading child collection with sort order
  15. How to create index in Entity Framework 6.2 with code first
  16. How do you ensure Cascade Delete is enabled on a table relationship in EF Code first?
  17. Entity Framework and calling context.dispose()
  18. mapping private property entity framework code first [duplicate]
  19. How to create index in Entity Framework 6.2 with fluent configuration
  20. EF Code First DBContext and Transactions
  21. Can you get the DbContext from a DbSet?
  22. Mocking or faking DbEntityEntry or creating a new DbEntityEntry
  23. What is the best practice in EF Core for using parallel async calls with an Injected DbContext?
  24. How to use Entity Framework to map results of a stored procedure to entity with differently named parameters
  25. DbContext AutoDetectChangesEnabled set to false detecting changes
  26. NSubstitute DbSet / IQueryable
  27. LINQ To Entities + Include + Anonymous type issue
  28. Why does EF5 code first use datetime2 when inserting a nullable datetime into the database?
  29. Can anyone spot why I keep getting this error testing the EF 5 beta
  30. Entity framework code first delete with cascade

Leave a Comment