EF Core mistakes costing you performance
In this video, I'll show you common EF Core performance mistakes that developers make every day, and how to fix them.
What You'll Learn:
SQL logging and query plan analysis for debugging bottlenecks
Change tracking optimization with AsNoTracking
Data projection techniques to reduce network traffic
Filtering strategies: Where, Take, Skip for efficient queries
SARGABLE vs Non-SARGABLE queries (index performance secrets)
Streaming large datasets with AsAsyncEnumerable
Bulk operations: ExecuteUpdateAsync vs SaveChanges
When to use Raw SQL and stored procedures
Subscribe for more content like this: https://www.youtube.com/c/TechWithPat...
Buy me a coffee: https://www.buymeacoffee.com/itsmepat...
TIMESTAMPS :
00:00 Intro
00:05 Logging
00:53 Query plan
01:15 NoTracking
02:16 Projection
02:57 Filtering
03:24 Indexes
04:24 Streaming
04:53 Bulk Operations
05:29 Raw SQL
05:52 Outro
Where you can find me:
💻 Github: https://github.com/techwithpat
🌐 Website: https://www.techwithpat.com
🕴️ LinkedIn: / patrick-tshibanda-431017135
#efcore #entityframework #dotnet