Interactive Tour of OrmLite

index.md

OrmLite

is a fast, simple, typed code-first ORM for .NET supporting most popular RDBMS's. For this interactive tour we'll use OrmLite's cross-platform In Memory SQLite database which can be referenced in Gistlyn by copying the packages.config NuGet generates after it installs it with:

> Install-Package ServiceStack.OrmLite.Sqlite

A copy of packages.config and test data.cs most examples use is available in:

• OrmLite Reference Test Data

Tip: quickly browse source code by navigating tabs with Ctrl + Left and Right arrow keys and use Ctrl + Enter to run Gists - see ? for more shortcuts

For a quick 1-page dive into OrmLite, checkout:

• OrmLite CRUD demo (async)
• OrmLite Rich CREATE Table Example

Try out features

See each section for more in-depth examples of OrmLite's features:

• SELECT Examples - Typed, Advanced, Custom and dynamic Queries with OrmLite
• INSERT Examples - Inserting records
• UPDATE Examples - Updating records
• DELETE Examples - Deleting records
• CREATE Table Examples - Creating Table Schemas for POCO Type definitions
• Modify Schema Examples - Modifying existing tables
• Other Features
• Async APIs
• Transaction Support
• Optimistic Concurrency
• Multitenancy
• Global Insert / Update Filters
• Exec, Result and String Filters
• Mocking
• Pluggable Complex Type Serializers
• Custom Configuration

---

< Home · SELECT Examples >