CloudYxt.ClickHouse
2.1.0
dotnet add package CloudYxt.ClickHouse --version 2.1.0
NuGet\Install-Package CloudYxt.ClickHouse -Version 2.1.0
<PackageReference Include="CloudYxt.ClickHouse" Version="2.1.0" />
paket add CloudYxt.ClickHouse --version 2.1.0
#r "nuget: CloudYxt.ClickHouse, 2.1.0"
// Install CloudYxt.ClickHouse as a Cake Addin #addin nuget:?package=CloudYxt.ClickHouse&version=2.1.0 // Install CloudYxt.ClickHouse as a Cake Tool #tool nuget:?package=CloudYxt.ClickHouse&version=2.1.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 (>= 1.5.4)
- CloudYxt.Common (>= 2.1.1)
- Microsoft.Extensions.ObjectPool (>= 6.0.16)
- 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.1.0 | 253 | 4/23/2023 |
| 2.0.0 | 443 | 7/14/2022 |
| 1.1.4 | 442 | 6/14/2022 |
| 1.1.3 | 418 | 6/14/2022 |
| 1.1.2 | 441 | 5/11/2022 |
| 1.1.1 | 1,582 | 11/26/2021 |
| 1.1.0 | 3,204 | 11/26/2021 |
| 1.0.11 | 344 | 8/4/2021 |
| 1.0.10 | 360 | 7/27/2021 |
| 1.0.9 | 400 | 7/27/2021 |
| 1.0.8 | 347 | 7/12/2021 |
| 1.0.7 | 310 | 7/8/2021 |
| 1.0.6 | 351 | 5/11/2021 |
| 1.0.5 | 310 | 4/30/2021 |
| 1.0.4 | 321 | 4/29/2021 |
| 1.0.3 | 351 | 4/20/2021 |
| 1.0.2 | 343 | 4/19/2021 |
| 1.0.1 | 340 | 4/19/2021 |
| 1.0.0 | 318 | 4/16/2021 |
云享通.Net Corec基于ClickHouse.Ado驱动建立常规数据操作库。
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()) {……}