Write read-optimized SQL queries with Dapper and EF Core.
npx skills add https://github.com/FaysilAlshareef/dotnet-ai-kit --skill dapper
Please help me install this Agent Skill. Skill: dapper Source: https://github.com/FaysilAlshareef/dotnet-ai-kit/tree/main/skills/data/dapper Command: npx skills add https://github.com/FaysilAlshareef/dotnet-ai-kit --skill dapper
Dapper provides a lightweight, high-performance alternative to EF Core for read-heavy operations where complex joins, multi-mapping, or reporting queries cause EF Core to be inefficient or overly verbose.
Use the dapper skill to implement a read-optimized query that returns paginated order summaries with dynamic filtering and multi-mapping.
High-intent search queries and answers about installing and using this skill.
Dapper executes read-optimized SQL queries alongside EF Core for complex joins and reporting. It maps joined results into DTO graphs for parent-child shapes like orders with items, avoiding EF Core inefficiencies and verbosity in heavy read operations.
Implement pagination and dynamic filtering with Dapper by using Dapper.SqlBuilder to construct performant paginated queries. SqlBuilder enables dynamic parameter binding for filtering conditions while maintaining parameterized CommandDefinition usage for safe query execution.
Yes, you can use Dapper alongside EF Core in the same .NET project by implementing an IDbConnectionFactory. This integration pattern allows EF Core to handle writes while Dapper manages high-performance read operations for complex joins and reporting.
To set up Dapper for read queries, you need Dapper and Dapper.SqlBuilder NuGet packages, an IDbConnectionFactory for DI registration, and CancellationToken-aware query execution using parameterized CommandDefinition objects for safe asynchronous operations.
Choose Dapper over EF Core for database queries when you need high-performance read operations involving complex joins, multi-mapping, or reporting. Dapper provides a lightweight alternative to EF Core where read-heavy operations cause EF Core to be inefficient or overly verbose.
congiulucImplement a Dapper-based repository against a generic IRepository<T> interface.
spallempatiGenerate optimized Dapper read queries with multi-mapping, pagination, and dynamic filtering.
FerranGuardiaApply EF6 Code-First patterns to manage DB schemas and data access.
FaysilAlshareefOptimize EF Core queries with AsNoTracking, projections, and split queries.
