Common Mistakes in EF Core with Jernej JK Kavka

When JK worked with many different clients and projects, he frequently heard “EF Core is slow” or “We should do this in raw SQL” only to realize they haven’t used EF Core correctly.

JK will show you how to improve your EF Core statements as well as how various configurations impacts the performance and scalability of your application. You’ll be blown away at how small changes can significantly impact not only the performance but also the stability of the application.

0:00 – About myself and agenda
2:44 – Intro – DB landscape, the pain and test environment
11:13 – 7 deadly sins
13:32 – #2 Counting and IQueryable
21:14 – #3 AsNoTracking
24:34 – #4 & #5 Implicit vs Explicit includes and Select
27:08 – #6 Pagination
31:08 – #7 Cancellation token
39:30 – Mini best practices
50:08 – Key takeaways
56:04 – Q&A

Code samples – https://github.com/jernejk/EFCoreSamples.StabilityAndPerformance
Rules to better EF – https://www.ssw.com.au/rules/rules-to-better-entity-framework
Rules to better Linq – https://www.ssw.com.au/rules/rules-to-better-linq
MS Docs on EF Core performance – https://docs.microsoft.com/en-us/ef/core/performance/

|| Subscribe for more content from SSW TV ||

|| Press like and leave a comment below to let us know how we’re doing ||

Twitter ↴
https://twitter.com/ssw_tv

Facebook ↴
https://www.facebook.com/SSW.page

——————————————————————————

About the Speaker:
https://www.ssw.com.au/people/jk

Jernej Kavka (JK) is a Microsoft AI MVP, SSW Solution Architect, and organizer of several user groups like APAC AI and Global AI The Podcast. JK is a full-stack .NET developer, but his passion lies in Azure Cognitive Services, AI and machine learning. He is the main architect behind SSW’s virtual receptionist – SophieAI: https://sswsophie.com

He is also very active in the developer community and enjoys speaking at conferences like NDC, DDD, as well as User Groups and Hack Days.

——————————————————————————
See more videos at http://tv.ssw.com

For more information about SSW’s web application consulting services, please visit https://www.ssw.com.au/ssw/Consulting/Web-Applications.aspx

Created by SSW TV | Videos By Developers, For Developers
v1