Entity Framework

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