CloudYxt.ClickHouse 1.0.11

There is a newer version of this package available.
See the version list below for details.
dotnet add package CloudYxt.ClickHouse --version 1.0.11
NuGet\Install-Package CloudYxt.ClickHouse -Version 1.0.11
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="1.0.11" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add CloudYxt.ClickHouse --version 1.0.11
#r "nuget: CloudYxt.ClickHouse, 1.0.11"
#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=1.0.11

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

云享通.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 netcoreapp2.0 was computed.  netcoreapp2.1 was computed.  netcoreapp2.2 was computed.  netcoreapp3.0 was computed.  netcoreapp3.1 was computed. 
.NET Standard netstandard2.0 is compatible.  netstandard2.1 was computed. 
.NET Framework net461 was computed.  net462 was computed.  net463 was computed.  net47 was computed.  net471 was computed.  net472 was computed.  net48 was computed.  net481 was computed. 
MonoAndroid monoandroid was computed. 
MonoMac monomac was computed. 
MonoTouch monotouch was computed. 
Tizen tizen40 was computed.  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.1.0 194 4/23/2023
2.0.0 417 7/14/2022
1.1.4 418 6/14/2022
1.1.3 391 6/14/2022
1.1.2 411 5/11/2022
1.1.1 1,550 11/26/2021
1.1.0 3,169 11/26/2021
1.0.11 311 8/4/2021
1.0.10 330 7/27/2021
1.0.9 366 7/27/2021
1.0.8 313 7/12/2021
1.0.7 283 7/8/2021
1.0.6 320 5/11/2021
1.0.5 274 4/30/2021
1.0.4 287 4/29/2021
1.0.3 324 4/20/2021
1.0.2 312 4/19/2021
1.0.1 302 4/19/2021
1.0.0 285 4/16/2021

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

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