Unlocking the Full Potential: The Harmonious Dance of EF Core and SQL Server
Every tool possesses untapped potential, waiting to be discovered. Explore the poetic synchronization between EF Core and SQL Server, as they join forces to create the most elegant solutions. Let’s embark on a journey from understanding basic scaffolding to the intricacies of schema evolution and SQL debugging. It’s time to be inspired by the art of database craftsmanship.
Along the way, we’ll uncover what happens beneath the surface and learn how to move beyond simply letting the tools generate the code for us. By understanding how EF Core translates our intentions into SQL, and how SQL Server executes those instructions, we can make better decisions, diagnose problems with confidence, and get the most out of both technologies.
Common mistakes in EF Core
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 stability of the application.