ClickHouse

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

View the NuGet package here or download it directly here.

RepoDb.ClickHouse (v1.17.0-alpha1)

Released: October 1, 2026

• Enhancement: Added the property handlers ClickHouseDecimalToDecimalPropertyHandler, ClickHouseDecimalToNullableDecimalPropertyHandler and ClickHouseDecimalToStringPropertyHandler, which map the Decimal32, Decimal64, Decimal128 and Decimal256 types into a decimal, a decimal? and a string property. #1342
• Enhancement: Added the property handler ClickHouseFixedStringToStringPropertyHandler, which maps the FixedString(N) type into a string property without the trailing NUL padding. #1342
• The property handlers of the RepoDb core package that target the ClickHouse types: BigIntegerToUInt128PropertyHandler and BigIntegerToNullableUInt128PropertyHandler (UInt128).
• Adopted the Roslyn and Meziantou static code analyzers across the codebase and applied the resulting fixes — including ConfigureAwait(false) on async calls, ArgumentNullException over NullReferenceException, and other code-quality corrections. #1328 #1331
• Updated the NuGet package icon to the new logo and refreshed the README with a consistent header, description and a link to the get started tutorial.
• Referenced the RepoDb package v1.17.0-alpha3.
• Unsealed ClickHouseDbSetting and added a UseClickHouse(GlobalConfiguration, ClickHouseDbSetting) overload that accepts any subclass, always applying the given setting even if already initialized — this lets ClickHouseBulkDbSetting (shipped by RepoDb.ClickHouse.BulkOperations) be registered the same way. #1360

RepoDb.ClickHouse (v1.16.0)

Released: September 9, 2026

Version bump only, aligning with the RepoDB ecosystem-wide v1.16.0 release — no functional changes since v1.0.0.

• Referenced the RepoDb package v1.16.0.

RepoDb.ClickHouse (v1.0.0)

Released: September 8, 2026

First general availability (non-preview) release of the ClickHouse provider, promoting the preview below to stable v1.0.0. No functional changes since the preview — see that entry for the full feature set and known limitations.

RepoDb.ClickHouse - Preview

Released: 2026-08-30

New

First release of the dedicated ClickHouse provider for RepoDB, built on top of ClickHouse.Driver. #1242

What’s included

• ClickHouseBootstrap / ClickHouseGlobalConfiguration.UseClickHouse() — initializes RepoDB for use with ClickHouseConnection (GlobalConfiguration.Setup().UseClickHouse()), mapping the ClickHouseDbSetting, ClickHouseDbHelper, and ClickHouseStatementBuilder to every ClickHouseConnection. An overload, UseClickHouse(IDbSetting), accepts a custom setting instance in place of the default ClickHouseDbSetting — see RepoDb.ClickHouse.BulkOperations’s ClickHouseBulkDbSetting.
• ClickHouseConnection, ClickHouseCommand and ClickHouseTransaction — RepoDB-aware subclasses of the driver’s own ADO.NET objects. ClickHouseCommand transparently strips the leading @ RepoDB adds to every parameter name, since ClickHouse.Driver expects unprefixed names. ClickHouseTransaction’s Commit()/Rollback() are no-ops, reflecting that ClickHouse has no traditional ACID transactions.
• ClickHouseDbSetting — ClickHouse-specific behavior: backtick (`) opening/closing identifier quotes, @ parameter prefix, no table hints, no native upsert keyword, and single-statement command text only (IsMultiStatementExecutable = false).
• ClickHouseStatementBuilder — generates ClickHouse-flavored SQL for every operation: LIMIT/LIMIT ... OFFSET paging for BatchQuery/skip-take queries, ALTER TABLE ... UPDATE/ALTER TABLE ... DELETE mutations for Update/UpdateAll/Delete, and a plain INSERT for Merge/MergeAll (deduplication deferred to the table engine). Insert/InsertAll throw NotSupportedException for entities with an identity field, since ClickHouse has no identity/auto-increment mechanism.
• ClickHouseDbHelper — schema/type discovery (GetFields/GetFieldsAsync) sourced from system.columns. GetScopeIdentity/GetScopeIdentityAsync always throw NotSupportedException.
• ClickHouseDbTypeNameToClientTypeResolver — maps ClickHouse column type names (unwrapping Nullable(...)/LowCardinality(...) and parameterized suffixes) to .NET CLR types.
• Parameter attributes: ClickHouseType, SourceColumn, SourceColumnNullMapping.
• Targets .NET 8, .NET 9, and .NET 10.

Known limitations (v1)

• No identity/auto-increment/sequence of any kind — key values must always be supplied by the caller.
• No native MERGE/upsert statement — Merge/MergeAll compile to a plain INSERT; use BulkMerge from RepoDb.ClickHouse.BulkOperations for a real matched/unmatched merge.
• UPDATE/DELETE are asynchronous mutations (ALTER TABLE ... UPDATE/DELETE) applied by background merges, not immediate row-level changes, and the WHERE clause is mandatory.
• Transactions are accepted for API compatibility only — Commit()/Rollback() are no-ops.
• Decimal columns require UseCustomDecimals=false on the connection string; otherwise they are returned as the driver’s own ClickHouseDecimal type instead of a plain decimal.
• Sub-second DateTime64 precision requires an explicit ClickHouseType attribute on the property — a plain DateTime CLR parameter is otherwise inferred as whole-second precision.

Bumps

• Referenced the RepoDb package.
• Referenced the ClickHouse.Driver package v1.3.0.