cqrs-query-generator

You can generate CQRS read queries with Dapper by providing a target entity name and fields to produce ready-to-use query templates, DTOs, and handlers for fast, no-tracking reads against a relational data store.

You can automate GetById, GetAll, GetPaged, Search, and Exists query patterns. The generator emits dedicated handlers, parameterized SQL, and response DTOs to ensure consistent, typed query templates across features.

Yes, the generated queries use multi-mapping and lightweight SQL to handle related detail queries like Get{Entity}ById, ensuring predictable data shapes and performance for complex relational data access.

You standardize data access by utilizing the included shared PagedList and ISqlConnectionFactory templates, which provide consistent paging structures and connection management across all generated CQRS read operations.

The best way to create typed response DTOs is to use an automated generator that maps parameterized SQL results directly to response DTOs, bypassing domain models for leaner and faster data access.

You should avoid using Dapper for CQRS read queries if your application requires heavy change tracking, complex object graph persistence, or if you prefer an ORM that abstracts raw SQL rather than executing lightweight, parameterized queries.