Learn it from developers who built it.
Tutorials, how-tos and deep dives on AI, .NET, C#, cloud and developer tools, written by the community.
Learn how EF Core compiled models reduce DbContext model initialization overhead, how to generate and configure them, and when startup performance benefits justify their added maintenance.
Learn how to use EF Core value converters to store enums as strings and map custom C# value objects to database columns.
Implement soft deletes in Entity Framework Core with an IsDeleted flag, global query filters, and a SaveChanges override. Learn how to hide, restore, and retain deleted records.
Learn how to roll back an application safely after database migrations, preserve data, check EF Core migration history, and use expand-and-contract deployments.
Learn how EF Core single and split queries handle related data, reduce cartesian explosion, and affect database round trips and performance.
Learn how to identify and fix N+1 query problems in GraphQL APIs using query logging, batching, DataLoader, and Entity Framework Core.
Learn how EF Core ExecuteUpdate performs bulk database updates without loading entities, and when it is preferable to modifying tracked entities with SaveChanges.
Learn when to use EF Core ExecuteUpdateAsync for set-based bulk updates instead of loading tracked entities, including effects on change tracking and database operations.
Learn how database transactions and Entity Framework Core prevent partial batch updates, handle rollbacks, and maintain data consistency in SQL Server.
Learn how to divide retry responsibility between ASP.NET Core applications and database providers, configure EF Core execution strategies, and avoid duplicate operations.
Learn how to test Entity Framework Core database migrations against production-like data, including representative datasets, integration tests, data-quality checks, and deployment risks.
Learn how to log and inspect Entity Framework Core SQL queries in ASP.NET Core using logging categories and LogTo, while avoiding exposure of sensitive data.
Learn how to improve EF Core query performance with no-tracking queries, split queries, and compiled queries for read-heavy and high-throughput workloads.
Compare EF Core and Dapper for ASP.NET Core Web APIs, and learn how to combine them in a CQRS-style architecture for maintainable writes and high-throughput reads.
Learn how to scrape EF Core metrics with Prometheus and build Grafana dashboards to monitor query rates, DbContext usage, SaveChanges activity, and cache efficiency.
Configure OpenTelemetry to collect EF Core performance metrics, verify them in the console, and export them to Prometheus for monitoring.
Configure OpenTelemetry tracing for Entity Framework Core to capture database query durations and SQL statements alongside ASP.NET Core request traces.
Learn how to log EF Core database commands and use a DbCommandInterceptor to detect, log, and monitor slow SQL queries.
Learn how to implement the transactional outbox pattern with EF Core to atomically store domain events and dispatch them reliably from a background service.
Build a dedicated EF Core migration console runner to apply database schema changes safely in CI/CD pipelines and Kubernetes deployments.
Learn how to use IDesignTimeDbContextFactory to create an EF Core DbContext for migrations without running Program.cs or the ASP.NET Core startup pipeline.
Learn why EF Core design-time migrations can log HostAbortedException and table-sharing warnings, and how to update Program.cs and entity relationships to resolve them.
Learn how to detect, measure, and fix the N+1 query problem in EF Core using SQL logging, query counting, Include(), Select(), and explicit loading.
EF Core 10's NativeAOT path is marked experimental — and it is. A hands-on walkthrough of the three bugs that block it (one with no workaround), verified by restructuring a real data layer, plus what to use instead today.
Learn how to identify and fix the N+1 query problem in Entity Framework Core using Include, projection, relationship queries, and efficient LINQ patterns to improve database performance.
Benchmark EF Core compiled queries on large production-style datasets to measure query execution time, allocations, throughput, and performance improvements under realistic workloads.
In Entity Framework Core (EF Core), query performance and memory management are heavily governed by one underlying mechanism: Change Tracking. While EF Core's default tracking behavior makes data mutations seamless, applying it blindly across read-only queries can introduce significant memory and CPU overhead. Understanding how the ChangeTracker operates under the hood—and knowing when to bypass it using AsNoTracking() or AsNoTrackingWithIdentityResolution()
Benchmark EF Core 11 complex-type indexes at scale. Measure query latency, reads, CPU, execution plans, and write overhead.
Evaluate EF Core 11 query translation changes with real workloads. Learn to benchmark, inspect SQL, and analyze execution plans for optimal performance.
Benchmark SQL Server vector search with EF Core. Explore exact vs. approximate search, performance factors, and best practices for RAG.
Everything on Entity Framework, not only its articles: the Entity Framework page →
Write an article and earn +1,000 SHARP when it is approved.
Write an article
