Documentation
Project Templates Vue React DTOs AI RAG PDF AutoQuery Auth OrmLite Redis
Project Templates Vue React DTOs AI RAG PDF AutoQuery Auth OrmLite Redis
OrmLite
  • Installation
  • Getting Started
  • API Overview
  • Async APIs
  • DB Migrations
  • Litestream
  • Install Postgres, MySql & MSSQL
  • Multiple App Databases
  • Scalable SQLite

OrmLite APIs

  • Select APIs
  • Insert APIs
  • Update APIs
  • Delete APIs
  • Schema APIs

Advanced Topics

  • Bulk Inserts
  • Type-Safe JSON Queries
  • Upsert
  • Async Tasks Builder
  • Reference Support
  • Typed Join Expressions
  • Dynamic Result Sets
  • Database Transactions
  • Type Converters
  • OrmLite Utils
  • Ensure APIs
  • Logging & Introspection
  • Complex Type Serializers
  • Insert & Update Filters
  • Custom SQL
  • SQL Customizations
  • Dictionary APIs

RDBMS specific features

  • SQL Server Features
  • PostgreSQL Features

Background Info

  • Optimistic Concurrency
  • Untyped APIs
  • AutoGen & T4 templates
  • Stored Procedures
  • Multi database connections
  • OrmLite Shippers example
  • Customer Orders example
  • AWS & RDS Support
  • Limitations

AutoGen & T4 Templates

AutoQuery AutoGen​

The recommended way to auto generate Tables and APIs for your existing RDBMS tables is to use AutoQuery AutoGen whose declarative nature allows us to easily generate AutoQuery & Crud Services using just declarative DTOs.

T4 Templates​

OrmLite's T4 Template are useful in database-first development or when wanting to use OrmLite with an existing RDBMS by automatically generating POCO's and strong-typed wrappers for executing stored procedures.

<PackageReference Include="ServiceStack.OrmLite.T4" Version="10.*" />

Edit this page on GitHub
Untyped APIs
Stored Procedures
On This Page
  • AutoQuery AutoGen
  • T4 Templates