CloudYxt.ClickHouse
2.2.0
dotnet add package CloudYxt.ClickHouse --version 2.2.0
NuGet\Install-Package CloudYxt.ClickHouse -Version 2.2.0
<PackageReference Include="CloudYxt.ClickHouse" Version="2.2.0" />
paket add CloudYxt.ClickHouse --version 2.2.0
#r "nuget: CloudYxt.ClickHouse, 2.2.0"
// 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 | Versions 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. |
-
.NETStandard 2.1
- ClickHouse.Ado (>= 2.0.5)
- CloudYxt.Common (>= 2.2.2)
- Microsoft.Extensions.ObjectPool (>= 6.0.36)
- Newtonsoft.Json (>= 13.0.3)
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()) {……}