CockroachDB

This page contains the latest information of the releases of RepoDb.CockroachDb library.

View the NuGet package here or download it directly here.

RepoDb.CockroachDb (v0.0.1-alpha1) - Preview

Released: September 26, 2026

New

First (alpha) release of the dedicated CockroachDB provider for RepoDB, built on top of the Npgsql-backed RepoDb.Connector.CockroachDb — a thin ADO.NET wrapper and type-mapping layer that exposes CockroachDB-specific, CockroachDb-prefixed objects (CockroachDbConnection, CockroachDbParameter, CockroachDbType, etc.).

What’s included

• CockroachDbBootstrap / CockroachDbGlobalConfiguration.UseCockroachDb() — initializes RepoDB for use with CockroachDbConnection (GlobalConfiguration.Setup().UseCockroachDb()), mapping the CockroachDbDbSetting, CockroachDbDbHelper, and CockroachDbStatementBuilder.
• CockroachDbDbSetting — CockroachDB-specific behavior: "-quoted identifiers, @ parameter prefix, public default schema, no table hints, no native UPSERT keyword (Merge is built via INSERT ... ON CONFLICT DO UPDATE instead), and multi-statement command text support (IsMultiStatementExecutable = true, MultiStatementSeparator = ";").
• CockroachDbStatementBuilder — generates CockroachDB-flavored SQL for every operation: LIMIT/LIMIT ... OFFSET paging, RETURNING-clause identity retrieval for Insert/InsertAll, and INSERT ... ON CONFLICT DO UPDATE ... RETURNING for Merge/MergeAll (with OVERRIDING SYSTEM VALUE so an explicit identity value on the entity is respected instead of silently ignored).
• CockroachDbDbHelper — schema/type discovery sourced from information_schema.columns (joined against pg_index/pg_namespace for primary-key and temp-schema detection), SELECT lastval(); for identity retrieval, a one-time retry against a fresh connection on NpgsqlOperationInProgressException, and per-parameter DateOnly/TimeOnly/non-UTC DateTime coercion (including inside arrays).
• Resolvers — ClientTypeToCockroachDbTypeResolver, CockroachDbConvertFieldResolver, CockroachDbDbTypeNameToClientTypeResolver, CockroachDbDbTypeNameToCockroachDbTypeResolver, and DbTypeToCockroachDbStringNameResolver.
• Property handlers — TsQueryToStringPropertyHandler and TsVectorToStringPropertyHandler, mapping the full-text search tsquery/tsvector types onto string properties (manual binding only).
• Parameter attributes mirroring CockroachDbParameter, settable per entity property: CockroachDbType, DbType, Direction, IsNullable, ParameterName, Precision, Scale, Size, SourceColumn, SourceColumnNullMapping, SourceVersion, and Value.
• Targets .NET 8 and .NET 10.

Known limitations (v1)

• RepoDb.Connector.CockroachDb is an independent, unofficial ADO.NET provider for CockroachDB (a thin wrapper over Npgsql) — not affiliated with or endorsed by Cockroach Labs, and still in early development.
• InsertAll’s generated key retrieval assumes the RETURNING clause of a multi-row INSERT returns rows in the same order they were listed — this has not been independently verified against CockroachDB.
• The spatial (geometry, geography) types have no CLR representation and resolve to typeof(object).
• No native GUID storage distinction beyond uuid — arrays and other CockroachDB-only types not listed by ClientTypeToCockroachDbTypeResolver throw when an explicit CockroachDbType can’t be inferred.

Bumps

• Referenced the RepoDb package v1.17.0-alpha2.
• References the RepoDb.Connector.CockroachDb package v0.0.1-alpha1.