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
| Name | Signature | Synopsis |
|---|---|---|
| Sqlite | Sqlite | SQLite with a provider such as Microsoft.Data.Sqlite. |
| PostgreSql | PostgreSql | PostgreSQL with a provider such as Npgsql. |
| SqlServer | SqlServer | 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. |
| Oracle | Oracle | Oracle Database 19c or later with Oracle.ManagedDataAccess.Core, on a session whose string comparisons are binary (NLS_COMP BINARY, Oracle's default). |
SQLite with a provider such as Microsoft.Data.Sqlite.
Returns
ProjectionSqlDialect
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