ClickHouse.Client

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

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.
• Correctly handles DateTime, including time zones
• Uses compressed binary protocol over HTTP(S)
• Supports bulk insertion
• Uses HTTP(S), so is compatible with any server version
• 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)

Documentation

Documentation for the library is available in repository Wiki