Entity Framework initialization is SLOW — what can I do to bootstrap it faster?

by

In pre EF6 view generation is known to be slow for bigger models. For now the solution is to use pregenerated views. This way you generate views at design time and are avoiding this work at runtime. To do that download EF power tools and select “Optimize Entity Data Model”. It will add a C# file to your project that contains views. The down side is that you will need to do it each time your model changes. Note: to generate views with the tool it will take about the same amount of time it takes to generate views at runtime (so sometimes you need to be patient). Here is a post about EF Power Tools that might be helpful: http://blogs.msdn.com/b/adonet/archive/2011/05/18/ef-power-tools-ctp1-released.aspx

Edit

Recently I created a different solution that is much more convenient to use (note it only works on EF6) – http://blog.3d-logic.com/2013/12/14/using-pre-generated-views-without-having-to-pre-generate-views-ef6/

More Related Contents:

  1. Why does the Contains() operator degrade Entity Framework’s performance so dramatically?
  2. Is DateTime.Now the best way to measure a function’s performance? [closed]
  3. Is “else if” faster than “switch() case”? [duplicate]
  4. How costly is .NET reflection?
  5. Performance differences between debug and release builds
  6. Performance surprise with “as” and nullable types
  7. Stopwatch vs. using System.DateTime.Now for timing events [duplicate]
  8. SQL Query slow in .NET application but instantaneous in SQL Server Management Studio
  9. What are Independent Associations and Foreign Key Associations? [duplicate]
  10. LINQ Ring: Any() vs Contains() for Huge Collections
  11. Exact time measurement for performance testing [duplicate]
  12. LEFT JOIN in LINQ to entities?
  13. String concatenation vs String Builder. Performance
  14. Entity Framework/SQL2008 – How to Automatically Update LastModified fields for Entities?
  15. Does Entity Framework 4 Code First have support for identity generators like NHibernate?
  16. The property ‘Id’ is part of the object’s key information and cannot be modified
  17. Float vs Double Performance
  18. Efficient way to delete a line from a text file
  19. How to write super-fast file-streaming code in C#?
  20. Performance of “direct” virtual call vs. interface call in C#
  21. Most efficient method of self referencing tree using Entity Framework
  22. DateTime.DayOfWeek micro optimization
  23. Entity Framework – default values doesn’t set in sql server table
  24. Ternary operator is twice as slow as an if-else block?
  25. HTTPWebResponse + StreamReader Very Slow
  26. XmlSerializer Performance Issue when Specifying XmlRootAttribute
  27. Entity Framework Multiple Object Contexts
  28. Repository Pattern, POCO, and Business Entities
  29. Fastest way to remove first char in a String
  30. Using Include in Entity Framework 4 with lambda expressions

Leave a Comment