CloudYxt.ClickHouse 1.0.6

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

Install-Package CloudYxt.ClickHouse -Version 1.0.6
dotnet add package CloudYxt.ClickHouse --version 1.0.6
<PackageReference Include="CloudYxt.ClickHouse" Version="1.0.6" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add CloudYxt.ClickHouse --version 1.0.6
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: CloudYxt.ClickHouse, 1.0.6"
#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.0.6

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

Release Notes

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

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()) {……}

NuGet packages

This package is not used by any NuGet packages.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version History

Version Downloads Last updated
1.0.6 37 5/11/2021
1.0.5 30 4/30/2021
1.0.4 32 4/29/2021
1.0.3 37 4/20/2021
1.0.2 40 4/19/2021
1.0.1 41 4/19/2021
1.0.0 46 4/16/2021