dev-dotnet-efcore

To fix N+1 query problems in EF Core, you need to identify missing eager loading patterns and implement efficient loading strategies. This skill provides actionable checklists for detecting N+1 queries and applying proper eager loading to optimize data access.

The best way to optimize EF Core performance is by implementing compiled queries, split queries, and bulk operations. This skill provides guidance on these performance tuning techniques to ensure production-grade database efficiency under high load.

To manage database migrations safely in .NET, you should generate idempotent migrations and follow best practices for schema changes. This skill offers guidance on refining database migrations to ensure robust and maintainable schema management.

You need split queries in EF Core when handling large result sets with multiple related collections to avoid cartesian explosion. This skill guides you on implementing split queries and configuring SQL logging to ensure production-grade database efficiency.

Yes, this EF Core optimization guidance applies directly to C#/.NET development environments requiring high-performance database interactions. It addresses change tracking and data access patterns specific to your .NET stack.