Classes · 2 min read

CockroachDbStatementBuilder

A class used to build the SQL statements for CockroachDB.

This class is the BaseStatementBuilder-derived implementation for CockroachDB. It is automatically registered by CockroachDbBootstrap — you do not need to instantiate it directly under normal use.

Constructors

public CockroachDbStatementBuilder()
public CockroachDbStatementBuilder(IDbSetting dbSetting,
    IResolver<Field, IDbSetting, string> convertFieldResolver = null,
    IResolver<Type, Type> averageableClientTypeResolver = null)

The parameterless constructor defaults convertFieldResolver to CockroachDbConvertFieldResolver.

CockroachDB-specific generation notes

Paging uses LIMIT/LIMIT ... OFFSET for Query/top-N queries and BatchQuery/skip-take queries.
Insert appends a trailing RETURNING ... AS "Result" clause so the generated/primary key is returned in the same round trip, casting it to its SQL type first when one can be resolved.
InsertAll builds a single multi-row INSERT ... VALUES (...), (...), ... with one trailing RETURNING clause for the whole batch — this assumes the returned rows come back in the same order the rows were listed, which has not been independently verified against CockroachDB.
Merge/MergeAll compile to INSERT ... ON CONFLICT (qualifiers) DO UPDATE SET ..., each with a trailing RETURNING clause (MergeAll also returns a per-row __RepoDb_OrderColumn parameter alongside the key, to align results back to the source rows). An identity column is inserted with OVERRIDING SYSTEM VALUE so an explicit value on the entity is respected instead of silently ignored.
Truncate is a plain TRUNCATE TABLE ... — no RESTART IDENTITY.
Passing a non-null hints argument to any Create* method throws NotSupportedException, since CockroachDbDbSetting.AreTableHintsSupported is false.

Usability

Use StatementBuilderMapper to override it with a custom implementation.

StatementBuilderMapper.Add(typeof(CockroachDbConnection), new MyCustomCockroachDbStatementBuilder(dbSetting), true);