Skip to main content
-
How-to guideEntity modeMap tables to typed entities, query with C# expressions, insert, update and delete, track changes and navigate relationships.
-
How-to guideRaw SQL with KMQLWrite the exact SQL you need, keep it portable across databases with KMQL markup, and map results to typed classes.
-
How-to guideRepository modeDeclare a repository interface and let Kiwi ORM derive the queries from the method names, with pagination and dependency-injection support.
-
How-to guideStored proceduresCall stored procedures through a typed C# class, including output values and multiple result sets.
-
How-to guideTransactionsGroup work from any access mode into one transaction, with savepoints and isolation levels.
-
How-to guideCommon table expressionsWrite standard and recursive CTEs as typed C# and let Kiwi ORM generate the correct WITH clause for each database.
-
How-to guideGenerate entities and migrationsGenerate typed entities from a live database, or turn entity changes into reviewable, versioned migrations, with one tool for every engine.
-
How-to guideAudit data accessRecord who changed what, redact sensitive values and route an audit trail to your own tooling from inside the data layer. Core provides the auditing hooks, and the Enterprise edition adds ready-made adapters.