Entity Framework is Too Slow. What are my options? [closed]

by

The fact of the matter is that products such as Entity Framework will ALWAYS be slow and inefficient, because they are executing lot more code.

I also find it silly that people are suggesting that one should optimize LINQ queries, look at the SQL generated, use debuggers, pre-compile, take many extra steps, etc. i.e. waste a lot of time. No one says – Simplify! Everyone wants to comlicate things further by taking even more steps (wasting time).

A common sense approach would be not to use EF or LINQ at all. Use plain SQL. There is nothing wrong with it. Just because there is herd mentality among programmers and they feel the urge to use every single new product out there, does not mean that it is good or it will work. Most programmers think if they incorporate every new piece of code released by a large company, it is making them a smarter programmer; not true at all. Smart programming is mostly about how to do more with less headaches, uncertainties, and in the least amount of time. Remember – Time! That is the most important element, so try to find ways not to waste it on solving problems in bad/bloated code written simply to conform with some strange so called ‘patterns’

Relax, enjoy life, take a break from coding and stop using extra features, code, products, ‘patterns’. Life is short and the life of your code is even shorter, and it is certainly not rocket science. Remove layers such as LINQ, EF and others, and your code will run efficiently, will scale, and yes, it will still be easy to maintain. Too much abstraction is a bad ‘pattern’.

And that is the solution to your problem.

More Related Contents:

  1. Entity Framework Find vs. Where
  2. LINQ to Entities does not recognize the method
  3. Which method performs better: .Any() vs .Count() > 0?
  4. Why are multi-dimensional arrays in .NET slower than normal arrays?
  5. Is it better to call ToList() or ToArray() in LINQ queries?
  6. Fake DbContext of Entity Framework 4.1 to Test
  7. What’s so wrong about using GC.Collect()?
  8. Entity Framework: table without primary key
  9. String.Join vs. StringBuilder: which is faster?
  10. how to use views in code first entity framework [closed]
  11. How to measure code performance in .NET?
  12. Is there a way to call a stored procedure with Dapper?
  13. Does Entity Framework support parallel async queries? [duplicate]
  14. How can you do paging with NHibernate?
  15. Why seal a class?
  16. Cannot attach the file *.mdf as database
  17. .NET LINQ query syntax vs method chain
  18. Batching DB commands in Entity Framework 4.0
  19. .net ORM Comparison [closed]
  20. instance of entity type cannot be tracked because another instance with same key value is tracked [closed]
  21. Can’t find ADO.net Entity Data Model template in VS2017
  22. Changing the type of an (Entity Framework) entity that is part of an inheritance hierarchy
  23. Horrible redraw performance of the DataGridView on one of my two screens
  24. Where to run a duplicate check for an entity
  25. How can I configure Entity Framework to automatically trim values retrieved for specific columns mapped to char(N) fields?
  26. Does .NET assembly size affect performance?
  27. Binding a GridView to a Dynamic or ExpandoObject object
  28. The model backing the ‘ApplicationDbContext’ context has changed since the database was created
  29. ‘ObjectContext’ vs ‘DbContext’ in Entity Framework
  30. Using Entity Framework entities as business objects?

Leave a Comment