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)

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

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)

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

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

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

MySql​

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

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

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

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

SQLite​

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

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

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

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

Community Providers​

Unofficial providers contributed and supported by ServiceStack Community users:

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

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

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:

npx add-in postgres

npx add-in sqlserver

npx add-in mysql

npx add-in sqlite

npx add-in oracle

npx add-in firebird

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

dotnet tool install -g x