CloudYxt.ClickHouse 1.1.4

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

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

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

Product Versions
.NET net5.0 net5.0-windows net6.0 net6.0-android net6.0-ios net6.0-maccatalyst net6.0-macos net6.0-tvos net6.0-windows
.NET Core netcoreapp2.0 netcoreapp2.1 netcoreapp2.2 netcoreapp3.0 netcoreapp3.1
.NET Standard netstandard2.0 netstandard2.1
.NET Framework net461 net462 net463 net47 net471 net472 net48
MonoAndroid monoandroid
MonoMac monomac
MonoTouch monotouch
Tizen tizen40 tizen60
Xamarin.iOS xamarinios
Xamarin.Mac xamarinmac
Xamarin.TVOS xamarintvos
Xamarin.WatchOS xamarinwatchos
Compatible target framework(s)
Additional computed target framework(s)
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
1.1.4 49 6/14/2022
1.1.3 42 6/14/2022
1.1.2 66 5/11/2022
1.1.1 1,384 11/26/2021
1.1.0 3,007 11/26/2021
1.0.11 161 8/4/2021
1.0.10 176 7/27/2021
1.0.9 212 7/27/2021
1.0.8 161 7/12/2021
1.0.7 137 7/8/2021
1.0.6 159 5/11/2021
1.0.5 132 4/30/2021
1.0.4 140 4/29/2021
1.0.3 171 4/20/2021
1.0.2 169 4/19/2021
1.0.1 171 4/19/2021
1.0.0 148 4/16/2021

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

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