create-dapper-query

What problem does it solve?

It helps you create a correct, convention-compliant Dapper SQL query and the related C# artifacts without mixing in EF Core logic or unsafe patterns.

Core Features & Use Cases

• SQL generation with guardrails: Produces a Dapper-ready SQL statement that follows repository conventions, including mandatory soft-delete filtering via deleted_at IS NULL.
• Repository-ready implementation: Adds the SQL constant in the Domain, updates the repository interface, implements the repository method in Infrastructure, and wires parameters properly.
• Test scaffolding and validation: Generates repository unit tests (including empty and non-empty result scenarios) and corresponding data mocks to keep behavior verifiable.
• Use case: When you need a custom read-only report or lookup (for example, “list orders with customer name and status”), this skill generates the SQL and all required code changes to support it end-to-end.

Quick Start

Use the create-dapper-query skill to create a Dapper query for listing order summaries by customer, including the SQL and the repository method plus tests.