Class SqlDialect

Namespace

eQuantic.Core.Data.Relational

Assembly

eQuantic.Core.Data.Relational.dll

A database's SQL flavour: identifier quoting, naming conventions, paging syntax, type names for DDL, and the rendering of the constructs that differ between engines (collection membership, tuple comparisons, generated-key retrieval). The shared relational engine renders everything else; a provider package is this class plus a driver.

public abstract class SqlDialect

Inheritance

object

SqlDialect

Derived

MySqlDialect

PostgreSqlDialect

SqlServerDialect

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Constructors

SqlDialect()

Initializes the dialect with the standard function translations.

protected SqlDialect()

Properties

FalseLiteral

The literal for an always-false predicate (an empty IN); some dialects have no FALSE.

public virtual string FalseLiteral { get; }

Property Value

string

Functions

The function translations this dialect knows — extend it with Map(string, Func<string, IReadOnlyList<string>, string>).

public SqlFunctionRegistry Functions { get; }

Property Value

SqlFunctionRegistry

GeneratedKeyDdl

The DDL column suffix declaring a database-generated key (e.g. GENERATED BY DEFAULT AS IDENTITY).

public abstract string GeneratedKeyDdl { get; }

Property Value

string

RequiresOrderByForLimit

Whether a limited query must carry an ORDER BY (SQL Server's OFFSET/FETCH); the key is used when unsorted.

public virtual bool RequiresOrderByForLimit { get; }

Property Value

bool

System

The OpenTelemetry db.system value (e.g. postgresql, mysql, mssql).

public abstract string System { get; }

Property Value

string

Methods

AddColumnSql(string, string, string)

The DDL adding a column to an existing table (added nullable, matching create-table semantics).

public virtual string AddColumnSql(string quotedTable, string quotedColumn, string sqlType)

Parameters

quotedTable string

The quoted table.

quotedColumn string

The quoted column.

sqlType string

The column's SQL type.

Returns

string

AlterColumnType(string, string, string)

The DDL altering a column's type (a dialect may need a cast clause).

public virtual string AlterColumnType(string quotedTable, string quotedColumn, string sqlType)

Parameters

quotedTable string

quotedColumn string

sqlType string

Returns

string

BindValue(object?)

Converts a value before binding (a dialect may need CLR-side coercion, e.g. arrays); identity by default.

public virtual object? BindValue(object? value)

Parameters

value object

Returns

object

CollectionContains(string, string, bool)

Renders a collection-membership test (member CONTAINS value / CONTAINS KEY) for stores with native collection columns; the base dialect cannot express it (the clause degrades to residual).

public virtual string CollectionContains(string column, string parameter, bool key)

Parameters

column string

The quoted column.

parameter string

The bound value's parameter marker.

key bool

Whether the test targets a map key.

Returns

string

CollectionMutation(string, string, bool, bool)

Renders a collection-mutating SET fragment (col = col + items), for stores with collection columns.

public virtual string CollectionMutation(string column, string parameter, bool remove, bool prepend)

Parameters

column string

The quoted column.

parameter string

The bound items' parameter marker.

remove bool

Whether the items are removed instead of added.

prepend bool

Whether added items go at the front.

Returns

string

ColumnName(string)

Applies the naming convention to a member name to produce its column name (snake_case by default).

public virtual string ColumnName(string memberName)

Parameters

memberName string

Returns

string

ConfigureParameter(DbParameter, object?)

Configures a just-created parameter for a bound value — the hook a dialect uses to type values its driver cannot infer (e.g. a dictionary into a jsonb parameter). The base dialect does nothing.

public virtual void ConfigureParameter(DbParameter parameter, object? value)

Parameters

parameter DbParameter

The parameter (its name and value are already set).

value object

The bound value.

CreateIndexSql(string, string, string, bool)

Builds a CREATE INDEX statement (idempotent where the dialect supports it; migration history guards re-runs otherwise).

public virtual string CreateIndexSql(string quotedName, string quotedTable, string columns, bool unique)

Parameters

quotedName string

The quoted index name.

quotedTable string

The quoted table.

columns string

The quoted key column list (with directions).

unique bool

Whether the index enforces uniqueness.

Returns

string

CreateIndexSql(string, string, string, bool, IndexMethod, string?)

The DDL creating an index with a structure and an optional filtered predicate (already rendered as a SQL fragment with inlined literals). The base dialect builds default-structure indexes, filtered or not; a method it has no structure for is rejected with guidance.

public virtual string CreateIndexSql(string quotedName, string quotedTable, string columns, bool unique, IndexMethod method, string? filter)

Parameters

quotedName string

The quoted index name.

quotedTable string

The quoted table.

columns string

The rendered key column list.

unique bool

Whether the index enforces uniqueness.

method IndexMethod

The index structure.

filter string

The rendered partial-index predicate, or null.

Returns

string

CreateTableSql(string, string)

Builds an idempotent CREATE TABLE statement.

public virtual string CreateTableSql(string quotedTable, string columnsDdl)

Parameters

quotedTable string

The quoted table.

columnsDdl string

The column declaration list.

Returns

string

DropColumnSql(string, string)

The DDL dropping a column from an existing table.

public virtual string DropColumnSql(string quotedTable, string quotedColumn)

Parameters

quotedTable string

The quoted table.

quotedColumn string

The quoted column.

Returns

string

InsertSql(string, string, string, string?)

Builds an INSERT, reading the generated key back when returningKey is supplied (RETURNING / OUTPUT INSERTED). The base dialect cannot read keys back — declare a client-generated key, or use a dialect that can.

public virtual string InsertSql(string quotedTable, string columns, string values, string? returningKey)

Parameters

quotedTable string

The quoted table.

columns string

The quoted column list.

values string

The bound value list.

returningKey string

The quoted generated-key column to read back, or null.

Returns

string

IsDocumentColumn(Type)

Whether a member of this CLR type maps as a document column (e.g. a scalar-keyed dictionary into PostgreSQL jsonb). The base dialect maps none — such members stay unmapped navigations.

public virtual bool IsDocumentColumn(Type type)

Parameters

type Type

The member's CLR type.

Returns

bool

LimitClause(string, string?)

The SQL fragment limiting a query to the bound row count after the bound offset (appended after ORDER BY).

public virtual string LimitClause(string limitParameter, string? offsetParameter)

Parameters

limitParameter string

offsetParameter string

Returns

string

Literal(object?)

Renders a value as an inline SQL literal — DDL (a filtered index's predicate) cannot carry bind parameters. Values a dialect cannot inline are rejected with guidance.

public virtual string Literal(object? value)

Parameters

value object

The value (already normalized by BindValue(object?)).

Returns

string

Quote(string)

Quotes an identifier (table or column name).

public abstract string Quote(string identifier)

Parameters

identifier string

Returns

string

SearchIndexSql(string, string, string)

The DDL materializing a model-declared search index (SearchIndex(...) / [SearchIndex]) on a text column, in execution order — empty when the dialect has no equivalent structure. The declaration never changes semantics (LIKE pushes down regardless); it only changes the plan, which is why a dialect without the structure ignores it instead of refusing.

public virtual IReadOnlyList<string> SearchIndexSql(string indexName, string quotedTable, string quotedColumn)

Parameters

indexName string

The unquoted index name (the dialect quotes it).

quotedTable string

The quoted table.

quotedColumn string

The quoted column.

Returns

IReadOnlyList<string>

SizedSqlType(Type, int, int, int)

The DDL type for a type with facets: varchar(n) for sized text, numeric(p,s) for sized decimals, the plain SqlType(Type) otherwise. Dialects override the spellings.

public virtual string SizedSqlType(Type type, int length, int precision, int scale)

Parameters

type Type

The stored CLR type.

length int

The maximum text length (0 = default).

precision int

The decimal precision (0 = default).

scale int

The decimal scale.

Returns

string

SizedTextType(int)

The sized text type (varchar(n) by default).

protected virtual string SizedTextType(int length)

Parameters

length int

The maximum length.

Returns

string

SqlType(Type)

The DDL type for a CLR type (used by CREATE TABLE migrations).

public abstract string SqlType(Type type)

Parameters

type Type

Returns

string

SqlType(RelationalColumn)

The DDL type for a column, honouring its declared facets (text length, decimal precision/scale).

public string SqlType(RelationalColumn column)

Parameters

column RelationalColumn

The column.

Returns

string

TableName(string)

Applies the naming convention to an entity name to produce its table name (snake_case by default).

public virtual string TableName(string entityName)

Parameters

entityName string

Returns

string

TupleComparison(IReadOnlyList<string>, ComparisonOperator, IReadOnlyList<string>)

Renders a row-wise tuple comparison; the base dialect cannot express it.

public virtual string TupleComparison(IReadOnlyList<string> columns, ComparisonOperator op, IReadOnlyList<string> parameters)

Parameters

columns IReadOnlyList<string>

The quoted columns.

op ComparisonOperator

The comparison operator.

parameters IReadOnlyList<string>

The bound values' parameter markers.

Returns

string