cqrs-query-generator
CQRS Query Generator
Overview
This skill generates Queries following the CQRS pattern. Queries are read-only operations that return data without modifying state. Key principles:
- Queries never modify state - Read-only operations
- Use Dapper for reads - Bypass EF Core for performance
- Return DTOs, not entities - Projection to response models
- Direct SQL queries - Optimized for the specific use case
Quick Reference
| Query Type | Use Case | Returns |
|---|---|---|
| GetById | Single entity by ID | Result<EntityResponse> |
| GetAll | All entities (with optional filtering) | Result<IReadOnlyList<EntityResponse>> |
| GetPaged | Paginated list | Result<PagedList<EntityResponse>> |
| Search | Filtered/searched results | Result<IReadOnlyList<EntityResponse>> |
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.
48dapper-query-builder
Generates optimized read queries using Dapper. Includes multi-mapping for joins, pagination, dynamic filtering, CTEs, and best practices for high-performance data access.
23quartz-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.
11