DuckDB

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

View the NuGet package here or download it directly here.

RepoDb.DuckDb (v0.0.1-alpha3) - Preview

Released: October 9, 2026

• Enhancement: Made the package NativeAOT and trimming compatible (IsAotCompatible), replacing the reflection-based and dynamic code paths with AOT-safe equivalents.
• Referenced the RepoDb package v1.17.0-beta1.

RepoDb.DuckDb (v0.0.1-alpha2) - Preview

Released: TBA

New

• Unsealed DuckDbDbSetting and added a UseDuckDb(GlobalConfiguration, DuckDbDbSetting) overload that accepts any subclass, always applying the given setting even if already initialized — this lets DuckDbBulkOperationsDbSetting (shipped by RepoDb.DuckDb.BulkOperations) be registered the same way. #1360
• Referenced the RepoDb package v1.17.0-alpha3.

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

Released: September 25, 2026

New

First (alpha) release of the dedicated DuckDB provider for RepoDB, built on top of DuckDB.NET. #1348

What’s included

• DuckDbBootstrap / DuckDbConfiguration.UseDuckDb() — initializes RepoDB for use with DuckDBConnection (GlobalConfiguration.Setup().UseDuckDb()), mapping the DuckDbDbSetting, DuckDbDbHelper, and DuckDbStatementBuilder to every DuckDBConnection. The UseDuckDb(addDefaultHandlers) overload controls whether DuckDbStreamToByteArrayPropertyHandler (byte[]) and DuckDbTimeOnlyToTimeSpanPropertyHandler (TimeSpan) are registered as default, type-level handlers (defaults to true); pass false to register your own instead.
• DuckDbDbSetting — DuckDB-specific behavior: "-quoted identifiers, $ parameter prefix/placeholder sigil, main 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 = ";").
• DuckDbStatementBuilder — generates DuckDB-flavored SQL for every operation: LIMIT/LIMIT ... OFFSET paging for BatchQuery/skip-take queries and top-N Query, INSERT ... ON CONFLICT DO UPDATE for Merge/MergeAll, and identity/primary-key retrieval via a RETURNING clause appended to Insert/InsertAll/Merge/MergeAll — DuckDB has no session-scoped “last identity” function.
• DuckDbDbHelper — schema/type discovery (GetFields/GetFieldsAsync) sourced from information_schema.columns, joined against duckdb_constraints() for primary-key detection and a sequence-backed DEFAULT (nextval(...)) for identity detection (DuckDB has no native AUTO_INCREMENT). It also strips the $ sigil from every ad-hoc parameter’s name after creation, to match DuckDB.NET’s bare-name binding convention.
• Resolver — DuckDbTypeNameToClientTypeResolver (maps information_schema.columns.data_type values to .NET CLR types, including HUGEINT/UHUGEINT to BigInteger).
• Property handlers — DuckDbStreamToByteArrayPropertyHandler (BLOB → byte[], auto-registered) and DuckDbTimeOnlyToTimeSpanPropertyHandler (TIME → TimeSpan, auto-registered), plus the manual-binding DuckDbTimeOnlyToNullableTimeSpanPropertyHandler (TimeSpan?), DuckDbDateOnlyToDateTimePropertyHandler, and DuckDbDateOnlyToNullableDateTimePropertyHandler (DATE).
• Parameter attributes mirroring DuckDBParameter, settable per entity property: SourceColumn, SourceColumnNullMapping, and SourceVersion.
• Targets .NET 8, .NET 9, and .NET 10.

Known limitations (v1)

• No stored procedure support — DuckDB has no equivalent construct.
• DuckDB.NET.Data.Full only supports net8.0 and later — unlike most other providers in this ecosystem, there is no .NET Standard 2.0 build.

Bumps

• Referenced the RepoDb package v1.17.0-alpha2.
• References the DuckDB.NET.Data.Full package v1.5.5.