Unofficial ADO.NET client for ClickHouse®, ultra-fast 'big data' relational database
Not affiliated with or endorsed by ClickHouse Inc.
- High-throughput
- Fully supports ClickHouse-specific types:
- Composite types:
Array,Tuple,Nullable,Nested,Map, including combinations - Specialized types:
IPv4,IPv6,UUID,DateTime64,LowCardinality,Enumetc. - Large arithmetic types:
(U)Int128,(U)Int256,Decimal128,Decimal256
- Composite types:
- Correctly handles
DateTime, including time zones - Supports bulk insertion
- Uses compressed binary protocol over HTTP(S)
- Available for .NET Core/Framework/Standard
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
SELECTqueries) - Works with ORM like Dapper, Linq2DB, Entity Framework Core etc.
Documentation for the library is available in repository Wiki
- Originally created by Oleg V. Kozlyuk
- ClickHouse is a registered trademark of ClickHouse, Inc. https://clickhouse.com