How to: Improve the performance of the Entity Framework
After writing code using entity framework for sometime and seeing the code base continue to grow I realized the importance of coding with performance in mind. There are things that come to mind like eager loading, but that alone won’t do much as your application continues to grow. Below are some key best practices I found on the web as well as links worthwhile examining as you look for ways to improve your performance:
Best Practice | Impact | Required Refactoring |
Pre-generated Your View | Major | Minor |
Use Small EDMX Files | Minor | Moderate |
Create Smart Connection Strings | Minor | Minor |
Disable Change Tracking | Minor | Minor |
Use Compiled Queries | Moderate | Moderate |
Be Careful With Includes | Moderate | Major |
Source:
http://www.codeproject.com/KB/database/PerfEntityFramework.aspx
You can also learn more at:
Love
Can we use Let's Encrypt, the free and open certificate authority?
Hola! gracias por la info, me sirvió el comando sacandole el nombre del server. En mi caso, fue una migración…
Yes 3rd option helped me too. I removed the WC key Values from config file then started working.
I know this is from 2014. But really, thank you!