CloudYxt.ClickHouse 2.2.0

dotnet add package CloudYxt.ClickHouse --version 2.2.0                
NuGet\Install-Package CloudYxt.ClickHouse -Version 2.2.0                
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.
<PackageReference Include="CloudYxt.ClickHouse" Version="2.2.0" />                
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add CloudYxt.ClickHouse --version 2.2.0                
#r "nuget: CloudYxt.ClickHouse, 2.2.0"                
#r directive can be used in F# Interactive and Polyglot Notebooks. 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=2.2.0

// Install CloudYxt.ClickHouse as a Cake Tool
#tool nuget:?package=CloudYxt.ClickHouse&version=2.2.0                

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

Product Compatible and additional computed target framework versions.
.NET net5.0 was computed.  net5.0-windows was computed.  net6.0 was computed.  net6.0-android was computed.  net6.0-ios was computed.  net6.0-maccatalyst was computed.  net6.0-macos was computed.  net6.0-tvos was computed.  net6.0-windows was computed.  net7.0 was computed.  net7.0-android was computed.  net7.0-ios was computed.  net7.0-maccatalyst was computed.  net7.0-macos was computed.  net7.0-tvos was computed.  net7.0-windows was computed.  net8.0 was computed.  net8.0-android was computed.  net8.0-browser was computed.  net8.0-ios was computed.  net8.0-maccatalyst was computed.  net8.0-macos was computed.  net8.0-tvos was computed.  net8.0-windows was computed. 
.NET Core netcoreapp3.0 was computed.  netcoreapp3.1 was computed. 
.NET Standard netstandard2.1 is compatible. 
MonoAndroid monoandroid was computed. 
MonoMac monomac was computed. 
MonoTouch monotouch was computed. 
Tizen tizen60 was computed. 
Xamarin.iOS xamarinios was computed. 
Xamarin.Mac xamarinmac was computed. 
Xamarin.TVOS xamarintvos was computed. 
Xamarin.WatchOS xamarinwatchos was computed. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

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
2.2.0 86 12/9/2024
2.1.0 263 4/23/2023
2.0.0 451 7/14/2022
1.1.4 449 6/14/2022
1.1.3 424 6/14/2022
1.1.2 449 5/11/2022
1.1.1 1,595 11/26/2021
1.1.0 3,213 11/26/2021
1.0.11 352 8/4/2021
1.0.10 367 7/27/2021
1.0.9 409 7/27/2021
1.0.8 357 7/12/2021
1.0.7 319 7/8/2021
1.0.6 360 5/11/2021
1.0.5 319 4/30/2021
1.0.4 333 4/29/2021
1.0.3 359 4/20/2021
1.0.2 351 4/19/2021
1.0.1 348 4/19/2021
1.0.0 327 4/16/2021

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

2.2.0
升级nuget依赖,安全更新

2.1.0
升级nuget
升级支持IdatatableRequest分页算法支持

2.0.0
升级包目标为netstandard2.1,升级nuget

1.1.4
增加两处连接状态检测

1.1.3
改进parameters的容错和ExecuteReader输出检测

1.1.2
更新nuget驱动版本

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