แก้ไข

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.

If you are upgrading an existing ADO.NET schema, also apply the appropriate migration scripts for the providers you use:

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
  • อัปเดตล่าสุดเมื่อ