Batching Like a Boss: Using IDbContextFactory for High-Performance EF Core Update

Batching Like a Boss: Using IDbContextFactory for High-Performance EF Core Updates

I love receiving feedback on my blog posts! After sharing “Batching Updates and Inserts: Making EF Core Work Smarter, Not Harder,” I received some great comments, especially from MaxiTB on Mastodon, which I wanted to share. Batch operations—whether inserting or updating multiple records—can quickly lead to performance issues, particularly when DbContext is misused. However, with the helpful support of IDbContextFactory …

Continue Reading
Query Tags: Debugging EF Core Like a Detective

Query Tags: Debugging EF Core Like a Detective

Imagine you’re a detective working on a big case. You’ve got a pile of clues (queries), but they’re all mixed together with no labels. Which one belongs to which part of the case? Frustrating, right? That’s what debugging EF Core queries feels like without Query Tags. But with Query Tags, it’s like a breath of fresh air, relieving the frustration and making the process more manageable.
Query Tags in EF Core are like sticky notes for your SQL. They allow you to label your queries, making it significantly easier to track down problems, optimize performance, and appear as a debugging wizard.

Continue Reading