OrmLite Installation

OrmLite packages are available on NuGet and can be installed using your IDE or by adding a PackageReference in your .csproj

PostgreSQL​

Supports .NET 6+, .NET Framework v4.7.2+ and .NET Standard 2.0 (.NET 5 and lower)

SQL Server​

Uses Microsoft.Data.SqlClient ADO .NET provider. Supports .NET 6+, .NET Framework v4.7.2+ and .NET Standard 2.0 (supports Apple Silicon/ARM)

Uses System.Data.SqlClient. Supports .NET 6+, .NET Framework v4.7.2+ and .NET Standard 2.0 (.NET 5 and lower)

MySql​

Uses Mysql.Data. Supports .NET 6+, .NET Framework v4.7.2+ and .NET Standard 2.0 (.NET 5 and lower)

Uses MySqlConnector. Supports .NET 6+, .NET Framework v4.7.2+ and .NET Standard 2.0 (.NET 5 and lower)

SQLite​

Uses Microsoft.Data.Sqlite. Supports .NET 6+, .NET Framework v4.7.2+ and .NET Standard 2.0 (supports Apple Silicon/ARM)

Uses System.Data.SQLite. Supports .NET 6+, .NET Framework v4.7.2+ and .NET Standard 2.0 (.NET 5 and lower)

Uses SQLitePCLRaw.bundle_cil for a managed implementation free of native binaries. Still in Preview but passes 100% test suite.

.NET 6 & .NET Standard 2.0 only packages​

The .Core packages contains only .NET 6 and .NET Standard 2.0 versions which can be used in ASP.NET Core Apps on .NET Framework:

Community Providers​

Unofficial providers contributed and supported by ServiceStack Community users:

Please raise support questions on StackOverflow or ServiceStack/Discuss for best chance to reach community users.

Quick install in ASP .NET Core with mix​

The quickest way to install OrmLite in existing ASP .NET Core projects is to mix in the desired RDBMS provider which both installs the required NuGet package and creates a Modular Startup configuration all setup to read your App's configured RDBMS connection string for instant utility:

If you don't have the dotnet x tool installed, it can be installed with: