CloudYxt.ClickHouse 1.1.1

Install-Package CloudYxt.ClickHouse -Version 1.1.1
dotnet add package CloudYxt.ClickHouse --version 1.1.1
<PackageReference Include="CloudYxt.ClickHouse" Version="1.1.1" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add CloudYxt.ClickHouse --version 1.1.1
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: CloudYxt.ClickHouse, 1.1.1"
#r directive can be used in F# Interactive, C# scripting and .NET Interactive. Copy this into the interactive tool or source code of the script to reference the package.
// Install CloudYxt.ClickHouse as a Cake Addin
#addin nuget:?package=CloudYxt.ClickHouse&version=1.1.1

// Install CloudYxt.ClickHouse as a Cake Tool
#tool nuget:?package=CloudYxt.ClickHouse&version=1.1.1
The NuGet Team does not provide support for this client. Please contact its maintainers for support.

云享通.Net Corec基于ClickHouse.Ado驱动建立常规数据操作库。

NuGet packages

This package is not used by any NuGet packages.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last updated
1.1.1 276 11/26/2021
1.1.0 503 11/26/2021
1.0.11 104 8/4/2021
1.0.10 104 7/27/2021
1.0.9 143 7/27/2021
1.0.8 102 7/12/2021
1.0.7 82 7/8/2021
1.0.6 106 5/11/2021
1.0.5 84 4/30/2021
1.0.4 87 4/29/2021
1.0.3 89 4/20/2021
1.0.2 87 4/19/2021
1.0.1 97 4/19/2021
1.0.0 104 4/16/2021

云享通.Net Corec基于ClickHouse.Ado驱动建立常规数据操作库。

1.1.1
更新依赖,细节修正

1.1.0
升级ClickHouse.Ado驱动至1.4.0,同时新增针对ClickHousePool的ExecuteBulkInsert

1.0.11
调整自恢复能力判断方法以保证连接的可靠性

1.0.10
增加连接池自恢复能力

1.0.8
增加连接检查参数,提高可靠性

1.0.7
新增连接池处理,可定义全局静态连接以供全局使用
public static ClickHousePool chConn = new ClickHousePool(chConnStr);

chConn.ExecuteNoQuery(……
chConn.ExecuteNoQuery(……

1.0.6
调整参数化时,无论插入、修改,当类型为DbType.Object时,全部转换为JSON字符串

1.0.5
调整分页Reader方法参数
增加ExecuteTodatatableResponse生成分页方法

1.0.4
新增常用的两种对象类型转换ToJsonObject和ToObjectJson
新增插入数据时将DbType.Object自动转换为JSON字符串的文本存储

1.0.3
增加ALTER TABLE时间格式兼容性

1.0.2
增加基于驱动的空值兼容和日期格式时区兼容

1.0.0:
基于ClickHouse.Ado驱动建立常规数据操作Helper,如:
db.ExecuteNoQuery("INSERT INTO 表名 (id, addTime) values(@id,'',@addTime,'')",
new ClickHouseParameter() { ParameterName = "id", Value = $"{Guid.NewGuid()}" },
new ClickHouseParameter() { ParameterName = "addTime", Value = DateTime.Now, DbType = DbType.DateTime });

db.ExecuteNoQuery("ALTER TABLE  表名 UPDATE data=@data where id=@id",
new ClickHouseParameter() { ParameterName = "id", Value = "dcca304c-c479-48a1-9d41-6f4e4f0df2de" },
new ClickHouseParameter() { ParameterName = "data", Value = $"{Guid.NewGuid()}" });

注意:ClickHouseConnection请在外围释放,如使用:using (var conn=new ClickHouseConnection()) {……}