ReadMeFeed / Community knowledge
Real questions. Useful conversations. Find the people who know your stack.
Decide between EF Core Global Query Filters and manual Where clauses for soft deletes. Learn how to implement automated filtering using interfaces and how to avoid common migration pitfalls.
Use ExecuteUpdate and ExecuteDelete in EF Core 7+ to issue a single SQL statement, but know what change tracking skips.
Stop manually adding .Where(x => !x.IsDeleted) to every query. Learn how to use EF Core Global Query Filters to implement a robust, systemic soft-delete pattern.
Step-by-step guide to adding EF Core 8 migrations in a .NET 8 class library, covering DbContext setup, CLI commands, runtime application, and idempotent script generation for CI/CD.
Use AsSplitQuery to avoid Cartesian duplication when loading several collection navigations in one Entity Framework Core query.
Add AsNoTracking to read-only queries to skip change-tracker snapshots without changing the generated SQL.
Compiled queries in EF Core pre‑compile LINQ into SQL, cutting translation cost by 30–50%. This guide shows when to use them, how to implement, a worked example, and the trade‑offs to keep in mind.
EF Core AsSplitQuery avoids Cartesian explosion by running one SQL query per included collection. Learn the mechanism, configuration, and limits.
Learn how to use EF Core Compiled Queries to eliminate LINQ-to-SQL translation overhead in high-throughput services, including a worked example and performance trade-offs.