Table of Contents

Class MySqlDialect

Namespace
eQuantic.Core.Data.MySql
Assembly
eQuantic.Core.Data.MySql.dll

MySQL's SQL flavour: snake_case naming, backtick identifiers, LIMIT/OFFSET, row-wise tuple comparisons, and AUTO_INCREMENT keys — which MySQL cannot read back from an insert (no RETURNING), so generated-key backfill is rejected with guidance: declare a client-generated key. Collection columns do not exist; collection clauses degrade to the gated client-side residual.

public class MySqlDialect : SqlDialect
Inheritance
MySqlDialect
Derived
Inherited Members

Properties

GeneratedKeyDdl

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

public override string GeneratedKeyDdl { get; }

Property Value

string

IntrospectColumnsSql

A query listing every column of the schema in use, as four values in order: the table's name, the column's name, its type spelled the way this dialect spells it in DDL, and whether it accepts null. null when the dialect cannot read its own catalogue, which makes drift unanswerable rather than answered wrongly.

Each dialect writes its own, and composes the type in SQL rather than leaving it to be reassembled from parts afterwards. Catalogues disagree about where a type's facets live — one keeps the whole spelling in a column, another splits length from precision from fractional seconds — and the disagreement is far better settled by the store that knows the answer. 

public override string? IntrospectColumnsSql { get; }

Property Value

string

Remarks

column_type rather than data_type: it carries the display width and the fractional-second precision that this dialect writes into its DDL — tinyint(1), datetime(6) — which data_type drops, and dropping them would make every boolean and every timestamp read as drift.

SupportsBulkInsert

Whether the engine has a native bulk-load path for this dialect (PostgreSQL COPY, SQL Server SqlBulkCopy, MySQL's bulk loader). BulkInsertAsync refuses on dialects that answer false rather than quietly running an ordinary batch — asking for a bulk load and getting row-by-row inserts is exactly the kind of silent cost this engine does not ship.

public override bool SupportsBulkInsert { get; }

Property Value

bool

System

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

public override string System { get; }

Property Value

string

Methods

AlterColumnType(string, string, string)

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

public override 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 override object? BindValue(object? value)

Parameters

value object

Returns

object

BulkInsertAsync(DbConnection, DbTransaction?, string, IReadOnlyList<RelationalColumn>, IReadOnlyList<object?[]>, CancellationToken)

Bulk-loads rows through the store's native mechanism. Implemented by the dialects that declare SupportsBulkInsert; each row carries the column values in columns order, already converted to their stored form by the engine.

public override Task<long> BulkInsertAsync(DbConnection connection, DbTransaction? transaction, string quotedTable, IReadOnlyList<RelationalColumn> columns, IReadOnlyList<object?[]> rows, CancellationToken cancellationToken)

Parameters

connection DbConnection

The open connection (inside the caller's transaction, when there is one).

transaction DbTransaction

The ambient transaction, or null.

quotedTable string

The quoted target table.

columns IReadOnlyList<RelationalColumn>

The target columns, in the order each row's values arrive.

rows IReadOnlyList<object[]>

The rows to load.

cancellationToken CancellationToken

The cancellation token.

Returns

Task<long>

The number of rows loaded.

Remarks

MySqlConnector's MySqlBulkCopy — the client-side bulk loader, which streams rows without a statement per row. Column mappings are explicit (ordinal to name), so the engine's row order is authoritative regardless of the table's physical column order.

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 override 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

Quote(string)

Quotes an identifier (table or column name).

public override string Quote(string identifier)

Parameters

identifier string

Returns

string

SqlType(Type)

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

public override string SqlType(Type type)

Parameters

type Type

Returns

string

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

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

public override 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
Edit this page