Entity Framework 6 - Knowledge Base (KB)

Entity Framework Vs Stored Procedures - Performance Measure

I'm trying to establish how much slower Entity Framework is over Stored Procedures. I hope to convince my boss to let us use Entity Framework for ease of development....Problem is I ran a performance test and it looks like EF is about 7 times slower than...

SQL Strategies for detecting what is causing a lock / long query

I have a query against an Azure SQL database that occasionally results in the following: ...If there aren't many users, this doesn't happen. But if there are, this happens regularly - the query takes a very long time to complete and my DTU percentage is ...