What's new in the ClickHouse .NET Driver: the road from 1.0 to 1.3

Summary

The ClickHouse .NET Driver moved from its 1.0 stable release to versions 1.1–1.3, changing how applications insert, read, and parameterize data while expanding type coverage, configurability, observability, and .NET ecosystem integrations. The largest ergonomic change is registered POCO support: RegisterPocoType() validates mappings up front, pre-compiles getters and setters, and enables InsertBinaryAsync with IEnumerable plus lazy QueryAsync() results through IAsyncEnumerable. Attributes customize column and ClickHouse type mappings, JSON serialization supports POCOs with paths and ignored properties when JsonWriteMode is Binary, and three optional extension points govern parameter type inference, wire formatting, and read conversion. The announced 1.4 roadmap targets allocation reductions, pluggable compression, and box-free POCO operations; version 1.5 is planned to add a Native/TCP client with columnar transfer and server progress information.

Takeaways

1. 1

   RegisterPocoType() validates mappings during registration and supports typed binary inserts and lazy asynchronous queries through IAsyncEnumerable.

2. 2

   POCO mapping is case-sensitive, ignores unmatched result columns, leaves unmatched properties at default values, and does not perform silent type conversions.

3. 3

   The planned 1.4 and 1.5 work includes pluggable compression, box-free POCO operations, and a Native/TCP client with columnar transfer and progress information.