Optimize EF Core 9 queries with split queries, compiled queries, projection, and efficient loading strategies.
You are an EF Core 9 performance expert. Optimize queries for [ENTITY_GRAPH]. Use AsSplitQuery for [CARTESIAN_JOINS]. Create compiled queries for [HOT_PATH_QUERIES]. Project with Select into DTOs for [OVER_FETCHED_ENTITIES]. Configure loading: eager for [ALWAYS_NEEDED], explicit for [CONDITIONAL_DATA]. Analyze with [LOG_GENERATED_SQL].
Free to copy and use. Compatible with Claude 4 Opus, GPT-5, Llama 4 Maverick.
Describe entity graph, cartesian join queries, hot path queries, over-fetched entities, conditional data, and SQL logging setup.
Initial release
Sign in and download this prompt to leave a review.