Entity Framework Find vs. Where

by

The point is that Find() starts by searching in the local cache of the context and then, if no match, sends a query to the DB.

Call to Where() always sends a query to the DB.

With EF 4, I used to think that SQL generated by Find() was too complex and, in some cases, led to a performance issue. So I always use Where() even with EF 5. I should check the SQL generated by Find() with EF 5.

So on paper, Find() is better because it uses the cache.

More Related Contents:

  1. Entity Framework is Too Slow. What are my options? [closed]
  2. ‘ObjectContext’ vs ‘DbContext’ in Entity Framework
  3. Like Operator in Entity Framework?
  4. How can I query for null values in entity framework?
  5. .NET Entity Framework and transactions
  6. Get Database Table Name from Entity Framework MetaData
  7. Can you use Microsoft Entity Framework with Oracle? [closed]
  8. “Items collection must be empty before using ItemsSource.”
  9. Undo changes in entity framework entities
  10. Update primary key value using entity framework
  11. HashSet versus Dictionary w.r.t searching time to find if an item exists
  12. Is is possible to check if an object is already attached to a data context in Entity Framework?
  13. Generate POCO classes in different project to the project with Entity Framework model
  14. What are Navigation Properties in Entity Framework for?
  15. LINQ to Entities does not recognize the method Int32 get_Item(Int32)
  16. How to set default value for POCO’s in EF CF?
  17. How to map table splitting in EF Code First?
  18. Can you get a Func (or similar) from a MethodInfo object?
  19. Organizationally, where should I put common queries when using Entity Framework Code First?
  20. DbContext discard changes without disposing
  21. Using entity framework on multiple databases
  22. Optimum file buffer read size?
  23. How do I improve ASP.NET MVC application performance?
  24. Which is faster: clear collection or instantiate new
  25. entity framework Unable to load the specified metadata resource [duplicate]
  26. IIS: web applications warmup
  27. Model First with DbContext, Fails to initialize new DataBase
  28. Validate data using DataAnnotations with WPF & Entity Framework?
  29. Getting exact error type in from DbValidationException
  30. Entity framework 4.3 run migrations at application start

Leave a Comment