ADO.NET database configuration

The following sections contain links to SQL scripts for configuring your database and the corresponding ADO.NET invariant used to configure ADO.NET providers in Orleans. Customize these scripts as needed for your deployment. Before executing scripts for Clustering, Persistence, or Reminders, you need to create the main tables using the Main scripts.

Main scripts

Database	Script	NuGet package	ADO.NET invariant
SQL Server	SQLServer-Main.sql	System.Data.SqlClient	System.Data.SqlClient
MySQL / MariaDB	MySQL-Main.sql	MySql.Data	MySql.Data.MySqlClient
PostgreSQL	PostgreSQL-Main.sql	Npgsql	Npgsql
Oracle	Oracle-Main.sql	ODP.net	Oracle.DataAccess.Client

Clustering

Database	Script	NuGet package	ADO.NET invariant
SQL Server	SQLServer-Clustering.sql	System.Data.SqlClient	System.Data.SqlClient
MySQL / MariaDB	MySQL-Clustering.sql	MySql.Data	MySql.Data.MySqlClient
PostgreSQL	PostgreSQL-Clustering.sql	Npgsql	Npgsql
Oracle	Oracle-Clustering.sql	ODP.net	Oracle.DataAccess.Client

Persistence

Database	Script	NuGet package	ADO.NET invariant
SQL Server*	SQLServer-Persistence.sql	System.Data.SqlClient	System.Data.SqlClient
MySQL / MariaDB	MySQL-Persistence.sql	MySql.Data	MySql.Data.MySqlClient
PostgreSQL	PostgreSQL-Persistence.sql	Npgsql	Npgsql
Oracle	Oracle-Persistence.sql	ODP.net	Oracle.DataAccess.Client

* If you’re using Orleans v3.x use this script template: https://github.com/dotnet/orleans/blob/3.x/src/AdoNet/Orleans.Persistence.AdoNet/SQLServer-Persistence.sql

Reminders

Database	Script	NuGet package	ADO.NET invariant
SQL Server	SQLServer-Reminders.sql	System.Data.SqlClient	System.Data.SqlClient
MySQL / MariaDB	MySQL-Reminders.sql	MySql.Data	MySql.Data.MySqlClient
PostgreSQL	PostgreSQL-Reminders.sql	Npgsql	Npgsql
Oracle	Oracle-Reminders.sql	ODP.net	Oracle.DataAccess.Client