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:
Tip: quickly browse source code by navigating tabs with
Ctrl
+Left
andRight
arrow keys and useCtrl
+Enter
to run Gists - see?
for more shortcuts
For a quick 1-page dive into OrmLite, checkout:
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