ReadMeFeed / Community knowledge
Real questions. Useful conversations. Find the people who know your stack.
Databases & messaging · #entityframeworkcore
Learn how to architect multi‑tenant isolation and soft‑delete logic with EF Core’s Global Query Filters. This guide covers requirements, minimal design, data boundaries, operational checks, failure modes, and when to adjust the pattern.
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.
Learn how to use EF Core’s AsNoTracking to skip change‑tracking, cut query time, and avoid unnecessary memory use. Includes a step‑by‑step guide, a concrete example, and verification tips.
EF Core Global Query Filters let you centralise soft‑delete logic. The filter automatically adds a WHERE clause to every query for a type, eliminating boilerplate and ensuring consistency. Learn how to configure, test, and be aware of common pitfalls.
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.
EF Core Owned Types let you embed value objects into an entity’s table, keeping the schema flat while preserving domain integrity. This guide covers the minimal design, trust boundaries, operational checks, failure modes, and when to shift to a separate entity.