dapper-query-builder
Dapper Query Builder
Overview
Dapper provides lightweight, high-performance data access:
- Raw SQL - Full control over queries
- Multi-mapping - Handle complex joins
- Parameterized queries - SQL injection protection
- Minimal overhead - Near ADO.NET performance
Quick Reference
| Method | Purpose | Use Case |
|---|---|---|
QueryAsync<T> |
Multiple rows | Lists, reports |
QueryFirstOrDefaultAsync<T> |
Single row | Get by ID |
QueryMultipleAsync |
Multiple result sets | Complex data |
ExecuteAsync |
No results | Insert/Update/Delete |
More from ronnythedev/dotnet-clean-architecture-skills
dotnet-clean-architecture
Scaffolds a complete .NET solution following Clean Architecture principles with proper layer separation (API, Application, Domain, Infrastructure). Creates project structure, dependency injection setup, and cross-cutting concerns configuration.
48quartz-background-jobs
Generates scheduled background jobs using Quartz.NET. Includes job definitions, triggers, cron scheduling, dependency injection, and persistent job store configuration.
15unit-testing
Generates unit tests for command and query handlers using xUnit and NSubstitute. Implements Arrange-Act-Assert pattern with comprehensive test coverage for success and failure scenarios.
12cqrs-command-generator
Generates CQRS Commands with Handlers, Validators, and Request DTOs following Clean Architecture patterns. Commands represent actions that modify state and return Result types for proper error handling.
12fluent-validation
Generates FluentValidation validators for commands and queries. Includes common validation rules, custom validators, async validation, and integration with MediatR pipeline behaviors.
11outbox-pattern
Implements the Outbox pattern for reliable domain event processing. Ensures events are persisted in the same transaction as the aggregate changes and processed asynchronously with guaranteed delivery.
10