ProjectionSqlDialectType

PackageFCQRS
Database SQL syntax supported by the transactional projection store.

Specification

Kind
Type
Members
4
Examples
0
SqliteSignature
Sqlite
PostgreSqlSignature
PostgreSql
SqlServerSignature
SqlServer
OracleSignature
Oracle

Summary

NameSignatureSynopsis
SqliteSqliteSQLite with a provider such as Microsoft.Data.Sqlite.
PostgreSqlPostgreSqlPostgreSQL with a provider such as Npgsql.
SqlServerSqlServerSQL Server 2016 or later (compatibility level 130 or higher) with Microsoft.Data.SqlClient, on a database whose default collation is binary, such as Latin1_General_100_BIN2_UTF8.
OracleOracleOracle Database 19c or later with Oracle.ManagedDataAccess.Core, on a session whose string comparisons are binary (NLS_COMP BINARY, Oracle's default).

Sqlite

Sqlite
Member
SQLite with a provider such as Microsoft.Data.Sqlite.

Returns

ProjectionSqlDialect

PostgreSql

PostgreSql
Member
PostgreSQL with a provider such as Npgsql.

Returns

ProjectionSqlDialect

SqlServer

SqlServer
Member
SQL Server 2016 or later (compatibility level 130 or higher) with Microsoft.Data.SqlClient, on a database whose default collation is binary, such as Latin1_General_100_BIN2_UTF8.

Returns

ProjectionSqlDialect

Oracle

Oracle
Member
Oracle Database 19c or later with Oracle.ManagedDataAccess.Core, on a session whose string comparisons are binary (NLS_COMP BINARY, Oracle's default).

Returns

ProjectionSqlDialect