ClickHouse.Client 7.14.0

.NET 6.0 This package targets .NET 6.0. The package is compatible with this framework or higher. .NET Standard 2.1 This package targets .NET Standard 2.1. The package is compatible with this framework or higher. .NET Framework 4.6.2 This package targets .NET Framework 4.6.2. The package is compatible with this framework or higher. 
dotnet add package ClickHouse.Client --version 7.14.0
                    


                    

                
NuGet\Install-Package ClickHouse.Client -Version 7.14.0
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package. 
<PackageReference Include="ClickHouse.Client" Version="7.14.0" />
For projects that support PackageReference, copy this XML node into the project file to reference the package. 
<PackageVersion Include="ClickHouse.Client" Version="7.14.0" />
                    


                            Directory.Packages.props
                        

                    

                
<PackageReference Include="ClickHouse.Client" />
                    


                            Project file
For projects that support Central Package Management (CPM), copy this XML node into the solution Directory.Packages.props file to version the package. 
paket add ClickHouse.Client --version 7.14.0
                    


                    

                
#r "nuget: ClickHouse.Client, 7.14.0"
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package. 
#addin nuget:?package=ClickHouse.Client&version=7.14.0
                    


                            Install as a Cake Addin
                        

                    

                
#tool nuget:?package=ClickHouse.Client&version=7.14.0
                    


                            Install as a Cake Tool

ClickHouse.Client

ADO.NET client for ClickHouse, ultra-fast 'big data' relational database

Latest version Downloads codecov License Tests

Key features

  • High-throughput
  • Fully supports ClickHouse-specific types:
    • Composite types: Array, Tuple, Nullable, Nested, Map, including combinations
    • Specialized types: IPv4, IPv6, UUID, DateTime64, LowCardinality, Enum etc.
    • Large arithmetic types: (U)Int128, (U)Int256, Decimal128, Decimal256
  • Correctly handles DateTime, including time zones
  • Supports bulk insertion
  • Uses compressed binary protocol over HTTP(S)
  • Available for .NET Core/Framework/Standard

Advantages

Compared to other existing .NET clients, ClickHouse.Client has following advantages

  • Does not have to buffer response, reducing memory usage
  • Offers wider support for ClickHouse-specific types
  • Is more compliant to ADO.NET standards (e.g. does not require calling 'NextResult' on SELECT queries)
  • Works with ORM like Dapper, Linq2DB, Entity Framework Core etc.

Documentation

Documentation for the library is available in repository Wiki

Acknowledgements

Originally created by Oleg V. Kozlyuk

Product 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.  net10.0 was computed.  net10.0-android was computed.  net10.0-browser was computed.  net10.0-ios was computed.  net10.0-maccatalyst was computed.  net10.0-macos was computed.  net10.0-tvos was computed.  net10.0-windows was computed. 
.NET Core netcoreapp3.0 was computed.  netcoreapp3.1 was computed. 
.NET Standard netstandard2.1 is compatible. 
.NET Framework net462 is compatible.  net463 was computed.  net47 was computed.  net471 was computed.  net472 was computed.  net48 is compatible.  net481 was computed. 
MonoAndroid monoandroid was computed. 
MonoMac monomac was computed. 
MonoTouch monotouch was computed. 
Tizen tizen60 was computed. 
Xamarin.iOS xamarinios was computed. 
Xamarin.Mac xamarinmac was computed. 
Xamarin.TVOS xamarintvos was computed. 
Xamarin.WatchOS xamarinwatchos was computed. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

NuGet packages (38)

Showing the top 5 NuGet packages that depend on ClickHouse.Client:

Package Downloads
Newguys.Sport

Package Description
FreeSql.Provider.ClickHouse

FreeSql 数据库实现，基于 ClickHouse.Client Ado.net
EntityFrameworkCore.ClickHouse

ClickHouse provider for Entity Framework Core.
SqlSugar.ClickHouseCore

.NET ORM ClickHouse 组件 文档地址：https://www.donet5.com/Home/Doc?typeId=2437
linq2db.LINQPad

Supported databases: IBM DB2 LUW/zOS, Firebird, IBM Informix, Microsoft Access, Microsoft Sql Server (+Azure), Microsoft Sql Server Compact, MySql, MariaDB, Oracle, PostgreSQL, SQLite, SAP HANA, SAP/Sybase ASE, ClickHouse.

GitHub repositories (7)

Showing the top 7 popular GitHub repositories that depend on ClickHouse.Client:

Repository Stars
DotNetNext/SqlSugar
.Net aot ORM SqlServer ORM Mongodb ORM MySql 瀚高 Postgresql ORM DB2 Hana 高斯 Duckdb C# VB.NET Sqlite ORM Oracle ORM Mysql Orm 虚谷数据库 达梦 ORM 人大金仓 ORM 神通ORM C# ORM , C# ORM .NET ORM NET9 ORM .NET8 ORM ClickHouse ORM QuestDb ,TDengine ORM,OceanBase ORM,GaussDB ORM,Tidb ORM Object/Relational Mapping
Xabaril/AspNetCore.Diagnostics.HealthChecks
Enterprise HealthChecks for ASP.NET Core Diagnostics Package
dotnetcore/FreeSql
.NET aot orm, VB.NET/C# orm, Mysql/PostgreSQL/SqlServer/Oracle orm, Sqlite/Firebird/Clickhouse/DuckDB orm, 达梦/金仓/虚谷/翰高/高斯 orm, 神通 orm, 南大通用 orm, 国产 orm, TDengine orm, QuestDB orm, MsAccess orm.
testcontainers/testcontainers-dotnet
A library to support tests with throwaway instances of Docker containers for all compatible .NET Standard versions.
linq2db/linq2db
Linq to database provider.
FastReports/FastReport
Free Open Source Reporting tool for .NET6/.NET Core/.NET Framework that helps your application generate document-like reports
akpaevj/OneSTools.EventLog
Библиотеки и готовые инструменты для чтения и экспорта журнала регистрации 1С в ClickHouse и ElasticSearch
Version Downloads Last Updated
7.14.0 46,934 5/5/2025
7.13.2 12,128 4/17/2025
7.13.1 50,061 3/23/2025
7.13.0 29,207 3/9/2025
7.12.0 3,630 3/9/2025
7.11.0 22,936 2/18/2025
7.10.1 12,976 2/5/2025
7.10.0 24,834 1/20/2025
7.9.1 110,649 11/20/2024
7.9.0 1,513 11/19/2024
7.8.3 560 11/19/2024
7.8.3-alpha1 168 11/7/2024
7.8.2 95,128 10/13/2024
7.8.1 5,308 10/12/2024
7.8.0 67,739 9/21/2024
7.7.3 28,084 8/28/2024
7.7.2 3,121 8/28/2024
7.7.1 2,424 8/27/2024
7.7.0 16,599 8/25/2024
7.6.2 19,204 8/5/2024
7.6.1 527 8/2/2024
7.6.0 66,385 7/19/2024
7.5.3 7,699 7/15/2024
7.5.2 1,419 7/11/2024
7.5.1 28,950 6/17/2024
7.5.0 65,667 5/13/2024
7.3.0 11,030 4/17/2024
7.2.2 32,065 4/7/2024
7.2.1 10,856 3/25/2024
7.2.0 7,098 3/20/2024
7.1.1 57,266 2/18/2024
7.1.0 6,388 2/14/2024
7.0.0 52,048 1/14/2024
7.0.0-alpha1 267 12/24/2023
6.8.1 247,993 11/11/2023
6.8.0 29,705 11/6/2023
6.7.5 80,226 9/27/2023
6.7.4 80,922 8/4/2023
6.7.3 16,590 7/25/2023
6.7.2 16,240 7/12/2023
6.7.1 18,610 7/1/2023
6.7.0 51,207 6/14/2023
6.6.0 157,690 5/10/2023
6.5.2 49,343 4/7/2023
6.5.0 23,399 3/10/2023
6.4.0 48,177 1/28/2023
6.3.0 25,839 12/21/2022
6.2.0 21,224 11/22/2022
6.1.1 43,946 10/30/2022
6.0.0 23,912 10/13/2022
5.1.1 81,990 9/19/2022
5.1.0 14,795 9/14/2022
5.0.4 11,366 8/31/2022
5.0.3 45,147 8/6/2022
5.0.2 21,114 7/4/2022
5.0.1 624 7/3/2022
5.0.0 772 7/3/2022
4.3.1 1,595 6/30/2022
4.3.0 744 6/29/2022
4.2.2 141,996 2/23/2022
4.2.1 29,848 1/29/2022
4.2.0 652 1/29/2022
4.1.0 16,690 12/22/2021
4.0.1.462 85,725 10/23/2021
3.2.0.421 94,568 8/8/2021
3.1.0.379 81,699 4/7/2021
3.0.0.357 100,287 12/23/2020
2.3.0.326 14,700 11/26/2020
2.2.1.285 28,178 9/24/2020
2.2.0.279 8,425 9/19/2020
2.1.0.269 4,584 8/19/2020
2.0.0.262 1,695 7/1/2020
1.3.0.243 1,238 6/1/2020
1.2.0.230 10,309 5/14/2020
1.1.1.204 6,723 4/14/2020
1.1.0.197 1,206 3/29/2020
1.0.1.181 968 3/4/2020
1.0.0.174 862 2/21/2020
0.7.0.157 914 2/8/2020
0.6.0.144 718 2/3/2020
0.6.0.135 722 1/31/2020
0.5.0.106 831 1/1/2020
0.4.0.93 761 12/30/2019
0.2.0.69 2,043 11/25/2019
0.1.0.56-dev 535 10/22/2019
0.1.0.49-dev 517 10/20/2019
0.1.0.40-dev 547 10/20/2019