Unlocking the Full Potential: The Harmonious Dance of EF Core and SQL Server
summary
Demos show how to get useful SQL telemetry with open Telemetry and Application Insights, how to label queries using a custom tag with context so a slow SQL statement maps back to the exact CLR method, and how turning a joined query into a split query cuts 30s wall time down to ~500ms in one case (around 200 users triggered the problem). Covers reading actual execution plans in SSMS/Azure Data Studio, adding EF Core indexes via migrations, and using EF constants to avoid parameter sniffing regressions.
AI-written summary · about
chapters (7)
- 0:00EF Core and SQL Server harmony
- 3:23EF Core complex SQL queries
- 19:19EF Core joins SQL generation
- 30:52EF Core query data duplication
- 40:20EF Core database indexes
- 50:10EF Core query optimization
- 54:31Q&A
related talks
56mEntity Framework debugging using SQL Server: A Detective Story
01h 00mGetting the best out of Entity Framework Core
01h 04mCommon mistakes in EF Core
01h 01m10 things you didn't know EF Core can do
49mPerformance Features in SQL Server and Azure SQL
52mWriting T-SQL code for the engine, not for you "more demos" by popular demand- 52mWriting T-SQL code for the engine, not for you "more demos" by popular demand
01h 05mCommon mistakes in EF Core