ReadMeFeed / Community knowledge
Real questions. Useful conversations. Find the people who know your stack.
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.
Compiled queries in EF Core cache the generated SQL plan, cutting LINQ translation overhead. This post walks through defining a compiled query, measuring its impact, and highlights lifetime and dynamic‑query pitfalls.
Goal Determine the recommended approach for preventing stale query results when a compiled query in EF Core 7+ captures a mutable property from the DbContext instance. Constraints and uncertainty The application uses a long‑running host with a shared compiled query cache across many short‑lived DbContext instances. Each context sets a runtime filter value on
entityframeworkcore