JauntyQ Documentation
JauntyQ is a compile-time SQL-to-C# source-generator ORM. You write real SQL in .sql files; JauntyQ validates it at build time against a committed schema snapshot and emits the fastest possible C#, typed getters by ordinal, no reflection, zero per-row boxing, no runtime SQL parsing. The generated code carries everything; the runtime package is intentionally near-empty.
How it works
- Pull a schema snapshot from your database into a JSON file you commit (
sqlserver,postgres,mysql, orsqlite). - Write queries as
.sqlfiles, versioned alongside the code that uses them. - At build time the generator parses those files against the snapshot and emits typed C# methods. If a column is renamed or a table drops, the build breaks, not production.
Because there is no reflection or runtime code generation, the emitted code is Native AOT and trim compatible.
These docs
- Why JauntyQ (and why not), the honest pitch: problems solved, problems deliberately not solved, and how to choose between JauntyQ, Jaunty, and EF Core.
- Pricing, free core, paid team-safety tier; flat per-organization pricing (Community, Team, Business, Enterprise); how the licensing works.
- Getting started, requirements, installing the packages, wiring the generator, and your first build.
- Learn by doing, a guided first hour against SQLite plus coding exercises, no database server required.
- Guides, task-focused walkthroughs: DDL as schema source, sequences, bulk insert, and migrating from Dapper/EF.
- Reference, the CLI, snapshot format, configuration, directives, dialect differences, diagnostics, and troubleshooting.
- Roadmap, where JauntyQ is headed.
For quickstart instructions and the full feature walkthrough, see the repository README.md.