dapper

What problem does it solve?

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.

Core Features & Use Cases

• Efficient read queries: Execute parameterized SQL for single-row lookups, lists, and aggregates with minimal overhead.
• Multi-mapping and joins: Map joined results into DTO graphs for orders with items or other parent-child shapes.
• Pagination and dynamic filtering: Build performant paginated queries using SqlBuilder and parameter binding.
• Integration patterns: Use an IDbConnectionFactory and DI registration to coexist with EF Core for writes while Dapper handles reads.

Quick Start

Use the dapper skill to implement a read-optimized query that returns paginated order summaries with dynamic filtering and multi-mapping.