How to Delete and Update Millions of Rows in EF Core Without Loading a Single Entity

How to Delete and Update Millions of Rows in EF Core Without Loading a Single Entity

The Code Every Developer Has Written and Regretted Most EF Core performance disasters are not exotic edge cases. They get written in the first sprint, look clean in code review, and only reveal themselves when row counts hit production scale. The pattern below has ended more than a few on-call rotations badly: On a development database with a few hundred …

Continue Reading

Accelerating EF Core with Compiled Queries

One of my passions is data! I love all forms of data and how to work with it. I am a .NET fanatic also and have been a fan of Entity Framework since 2008. It has gotten so good since .NET Core 1.0, and I love to push EF Core to the limit, especially around Web APIs. In this blog post, I want to share my ideas about Compiled Queries in EF Core.

Continue Reading