DuckDB.NET.Bindings
1.1.3
dotnet add package DuckDB.NET.Bindings --version 1.1.3
NuGet\Install-Package DuckDB.NET.Bindings -Version 1.1.3
<PackageReference Include="DuckDB.NET.Bindings" Version="1.1.3" />
paket add DuckDB.NET.Bindings --version 1.1.3
#r "nuget: DuckDB.NET.Bindings, 1.1.3"
// Install DuckDB.NET.Bindings as a Cake Addin #addin nuget:?package=DuckDB.NET.Bindings&version=1.1.3 // Install DuckDB.NET.Bindings as a Cake Tool #tool nuget:?package=DuckDB.NET.Bindings&version=1.1.3
DuckDB.NET
DuckDB bindings for C#
Usage
dotnet add package DuckDB.NET.Data.Full
using (var duckDBConnection = new DuckDBConnection("Data Source=file.db"))
{
duckDBConnection.Open();
using var command = duckDBConnection.CreateCommand();
command.CommandText = "CREATE TABLE integers(foo INTEGER, bar INTEGER);";
var executeNonQuery = command.ExecuteNonQuery();
command.CommandText = "INSERT INTO integers VALUES (3, 4), (5, 6), (7, 8);";
executeNonQuery = command.ExecuteNonQuery();
command.CommandText = "Select count(*) from integers";
var executeScalar = command.ExecuteScalar();
command.CommandText = "SELECT foo, bar FROM integers";
var reader = command.ExecuteReader();
PrintQueryResults(reader);
}
private static void PrintQueryResults(DbDataReader queryResult)
{
for (var index = 0; index < queryResult.FieldCount; index++)
{
var column = queryResult.GetName(index);
Console.Write($"{column} ");
}
Console.WriteLine();
while (queryResult.Read())
{
for (int ordinal = 0; ordinal < queryResult.FieldCount; ordinal++)
{
var val = queryResult.GetInt32(ordinal);
Console.Write(val);
Console.Write(" ");
}
Console.WriteLine();
}
}
Known Issues
When debugging your project that uses DuckDB.NET library, you may get the following error: System.AccessViolationException: Attempted to read or write protected memory. This is often an indication that other memory is corrupt. The error happens due to debugger interaction with the native memory. For a workaround check out Debugger Options mess up debugging session during Marshalling
Documentation
Documentation is available at https://duckdb.net
Support
If you encounter a bug with the library Create an Issue. Join the DuckDB dotnet
channel for DuckDB.NET-related topics.
Contributors
Sponsors
A big thanks to DuckDB Labs and AWS Open Source Software Fund for sponsoring the project!
Product | Versions Compatible and additional computed target framework versions. |
---|---|
.NET | net5.0 was computed. net5.0-windows was computed. net6.0 is compatible. net6.0-android was computed. net6.0-ios was computed. net6.0-maccatalyst was computed. net6.0-macos was computed. net6.0-tvos was computed. net6.0-windows was computed. net7.0 was computed. net7.0-android was computed. net7.0-ios was computed. net7.0-maccatalyst was computed. net7.0-macos was computed. net7.0-tvos was computed. net7.0-windows was computed. net8.0 is compatible. net8.0-android was computed. net8.0-browser was computed. net8.0-ios was computed. net8.0-maccatalyst was computed. net8.0-macos was computed. net8.0-tvos was computed. net8.0-windows was computed. net9.0 was computed. net9.0-android was computed. net9.0-browser was computed. net9.0-ios was computed. net9.0-maccatalyst was computed. net9.0-macos was computed. net9.0-tvos was computed. net9.0-windows was computed. |
.NET Core | netcoreapp2.0 was computed. netcoreapp2.1 was computed. netcoreapp2.2 was computed. netcoreapp3.0 was computed. netcoreapp3.1 was computed. |
.NET Standard | netstandard2.0 is compatible. netstandard2.1 was computed. |
.NET Framework | net461 was computed. net462 was computed. net463 was computed. net47 was computed. net471 was computed. net472 was computed. net48 was computed. net481 was computed. |
MonoAndroid | monoandroid was computed. |
MonoMac | monomac was computed. |
MonoTouch | monotouch was computed. |
Tizen | tizen40 was computed. tizen60 was computed. |
Xamarin.iOS | xamarinios was computed. |
Xamarin.Mac | xamarinmac was computed. |
Xamarin.TVOS | xamarintvos was computed. |
Xamarin.WatchOS | xamarinwatchos was computed. |
-
.NETStandard 2.0
- System.Runtime.CompilerServices.Unsafe (>= 6.0.0)
-
net6.0
- No dependencies.
-
net8.0
- No dependencies.
NuGet packages (1)
Showing the top 1 NuGet packages that depend on DuckDB.NET.Bindings:
Package | Downloads |
---|---|
DuckDB.NET.Data
DuckDB ADO.NET Provider for C#. This package does not include a copy of the native DuckDB library. |
GitHub repositories
This package is not used by any popular GitHub repositories.
Version | Downloads | Last updated |
---|---|---|
1.1.3 | 1,416 | 2 months ago |
1.1.2.1 | 22,708 | 3 months ago |
1.1.2-alpha.5 | 64 | 3 months ago |
1.1.1 | 8,338 | 4 months ago |
1.1.0.1 | 2,230 | 4 months ago |
1.0.2 | 4,869 | 6 months ago |
1.0.1 | 44,680 | 7 months ago |
1.0.0 | 4,923 | 7 months ago |
0.10.3 | 775 | 8 months ago |
0.10.2 | 19,618 | 9 months ago |
0.10.1 | 624 | 10 months ago |
0.9.2 | 131,860 | 11/14/2023 |
0.9.1 | 27,092 | 10/13/2023 |
0.9.0.3 | 5,420 | 10/4/2023 |
0.9.0 | 1,111 | 10/2/2023 |
0.8.1 | 98,122 | 7/8/2023 |
0.8.0 | 16,929 | 5/17/2023 |
0.7.1 | 599 | 3/4/2023 |
0.6.1 | 265 | 1/8/2023 |
0.4.0.10 | 1,732 | 9/3/2022 |
0.4.0.1 | 1,876 | 7/6/2022 |
0.4.0 | 869 | 6/27/2022 |
0.2.9.1 | 3,331 | 9/24/2021 |
0.2.9 | 617 | 9/15/2021 |
0.1.3 | 622 | 9/3/2021 |
0.1.2 | 812 | 4/12/2021 |
0.1.1 | 627 | 4/9/2021 |
0.1.0 | 970 | 11/12/2020 |
Added support for creating user-defined table valued functions.
Added support for passing LIST parameter types
Updated to DuckDB v1.1.3