Edit

Share via

ADO.NET database configuration

  • Article

The following sections contain links to SQL scripts to configure your database as well as the corresponding ADO.NET invariant used to configure ADO.NET providers in Orleans. These scripts are intended to be customized if needed for your deployment. Before executing scripts for Clustering, Persistence, or Reminders, one needs to create main tables with 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