1. how to improve the performace of EF
https://www.simple-talk.com/dotnet/net-tools/entity-framework-performance-and-what-you-can-do-about-it/
small tool for mvc asp.net etc, to see the excution plan :
http://www.red-gate.com/products/dotnet-development/ants-performance-profiler/index?utm_source=simpletalk&utm_medium=publink&utm_campaign=antsperformanceprofiler&utm_content=entityframeworkperformance
2.EF Related
https://www.simple-talk.com/dotnet/.net-framework/deploying-an-entity-framework-database-into-production/
3. EF Aasync && await
https://www.simple-talk.com/dotnet/.net-framework/the-.net-4.5-asyncawait-feature-in-promise-and-practice/
4. SQL Optimize
https://www.simple-talk.com/blogs/using-optimize-for-ad-hoc-workloads/
5 SQL Server Index basics
https://www.simple-talk.com/sql/learn-sql-server/sql-server-index-basics/
6. https://msdn.microsoft.com/en-us/library/aa937723(v=vs.113).aspx