ZLSoft.QWPlatform.DBServiceCore
4.0.0
See the version list below for details.
dotnet add package ZLSoft.QWPlatform.DBServiceCore --version 4.0.0
NuGet\Install-Package ZLSoft.QWPlatform.DBServiceCore -Version 4.0.0
<PackageReference Include="ZLSoft.QWPlatform.DBServiceCore" Version="4.0.0" />
paket add ZLSoft.QWPlatform.DBServiceCore --version 4.0.0
#r "nuget: ZLSoft.QWPlatform.DBServiceCore, 4.0.0"
// Install ZLSoft.QWPlatform.DBServiceCore as a Cake Addin
#addin nuget:?package=ZLSoft.QWPlatform.DBServiceCore&version=4.0.0
// Install ZLSoft.QWPlatform.DBServiceCore as a Cake Tool
#tool nuget:?package=ZLSoft.QWPlatform.DBServiceCore&version=4.0.0
v4.0.0.0(why) 修改为netstandard2.1的框架，支持.net全系列的版本
v3.4.4.1(why) 1.修改获取数据库表结构列时的bug
v3.4.4.0(why) 1.修改获取单独获取事务对象时崩溃的bug 2.升级Oracle的驱动，支持.net6.0的运行时
v3.4.3.9（why） 1.增加支持达梦数据库驱动
v3.4.3.8 1.Oracle允许可空数据类型 v3.4.3.7 1.实现Oracle的批量插入（InsertList功能） 2.实现Oracle的读取未提交的事务数据 v3.4.3.6 增加获取Sql语句的读取便利性,直接集成读取执行为一体
如：var dt2 = db.GetSql("FS_SF_GetBillsChargedList")
.Condition("visit_id", 1 > 1)
.Condition("pt_id", () => { return false; })
.Builder() //执行一次Builder,相当于生成了SqlBuilder对象
.Parameters("@org_id", "1")
.Parameters("@visit_id", "123")
.Parameters("@pt_id", "123")
.Select(); //执行SQL
v3.4.3.5 修正批量插入的bug v3.4.3.4 修改批量插入方式提高性能（why:2023-03-06） v3.4.3.2 查询增加WriteLog方法记录sql v3.4.2 查询语句支持事务中未提交的数据 v3.3.0 升级npgsql 6.0.4 3.1.0.0 升级npgsql引用 3.0.7.45 修复mysql查询结果存在null时报错的问题 3.0.7.44 增加对mysql的支持、对关键字使用反括号包裹 3.0.7.43 IDeleteBulider 增加queryAndWhereList、whereParametersList方法 3.0.7.42 1.Fix更新构造器中的列值获取bug（事件传递相关参数） 2.增加提交事务时事务 3.0.7.37 修正Oracle中定时获取数据库时间的异�访问已释放的对象异常) 3.0.7.36 优化获取SQL脚本信息获取 3.0.7.35 更新SQL执行统计信息，不再写入缓存中 3.0.7.34 批量新增与批量更新（db.InsertList(list) & UpdateList) v3.0.7.33 发布构建器属性访问功能（Insert/Update/Delete) v3.0.7.32 紧急修正事务锁表的bug v3.0.7.31 增加根据数据表获取列集合功能 v3.0.7.30 增加Model中使用枚举值功� v3.0.7.28 1.增加update可以基于原始值操作例 a=a+1 2.增加where自定义操作符中大于等于和小于等于 v3.0.7.27 1.可以自定义条件比较符（select, update ,delete) v3.0.7.26 1.优化数据库事务日志输出与事务对象为空判断 v3.0.7.25 1.修正数据库获取时间的Bug v3.0.7.24 1.默认使用长连接，同一个db对象中连接通道在整个生命周期中有效 2.修改事务，必须在结束时手动db.commit保证事务手动提交
v3.0.7.23 select与sql分页时的bug解决 v3.0.7.22 实现委托事务处理 v3.0.7.21 实现SQL脚本统一监听功能 v3.0.7.19-3.0.7.20 修改查询时如果为null值。则赋值为DBNull.Value v3.0.7.18 修改事务Bug v3.0.7.17 修改数据库连接手动释� v3.0.7.16 实现SQL条件使用where自定义sql语句 v3.0.7.15 实现sql脚本修改时更新缓存功依赖于Redis的缓 实现数据对码功能netcore版本 3.0.7.14 1.修正SQL分页时传递参数属于集合的异常 3.0.7.13 1.增加SQL脚本的附加条件片断（排序分组SQL） v3.0.7.12 1.修改读取配置文件夹小写问题 2.PG数据库更新为4.1.3 3.Oracle数据库更新为2.19.6 v3.0.7.10 修改PG数据库多并发的事务时未能正确判断连接对象问题 v3.0.7.9 fix:修正zltools创建的脚本无法在netcore的环境上访问问题 v3.0.7.8 fix:PG数据库无法保存日期时间格 v3.0.7.7 fix数据库事务没有回滚的bug v3.0.7.5,v3.0.7.6 fix:pg库分页的bug v1.0.7.3 支持netcore 3.0 v1.0.7.3 1.修改数据库支持方�修正)
v1.0.7.2 1.实现简化数据库访问方式 2.支持PG数据库源驱动 3.SQL执行内容输出 v1.0.7 1.实现基于net core 2.0框架访问 v1.0.6 1.修改Logger的命名空间路�直接引用QWPlatform.SystemLibrary即可使用
| 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
- dmdbms.DmProvider (>= 1.1.0.16649)
- MySql.Data (>= 8.0.31)
- Npgsql (>= 6.0.4)
- Oracle.ManagedDataAccess.Core (>= 3.21.110)
- System.Data.SqlClient (>= 4.8.1)
- System.Data.SQLite (>= 1.0.112)
- ZLSoft.QWPlatform.SystemLibraryCore (>= 4.0.0)
NuGet packages (1)
Showing the top 1 NuGet packages that depend on ZLSoft.QWPlatform.DBServiceCore:
| Package | Downloads |
|---|---|
|
ZLSoft.QWPlatform.WebBasics
基础服务 |
GitHub repositories
This package is not used by any popular GitHub repositories.
| Version | Downloads | Last updated |
|---|---|---|
| 6.0.0 | 927 | 12/28/2021 |
| 4.0.0.1 | 70 | 4/3/2024 |
| 4.0.0 | 87 | 2/26/2024 |
| 3.4.3.8 | 161 | 7/12/2023 |
| 3.4.3.7 | 156 | 7/12/2023 |
| 3.4.3.5 | 355 | 3/22/2023 |
| 3.4.3.2 | 558 | 11/30/2022 |
| 3.4.3.1 | 411 | 10/12/2022 |
| 3.4.3 | 522 | 8/26/2022 |
| 3.4.2 | 1,592 | 8/1/2022 |
| 3.3.0.1 | 1,281 | 6/28/2022 |
| 3.3.0 | 1,011 | 6/27/2022 |
| 3.2.0-alpha2 | 181 | 5/17/2022 |
| 3.2.0-alpha1 | 183 | 5/17/2022 |
| 3.0.7.44 | 17,308 | 5/7/2021 |
| 3.0.7.43 | 2,343 | 4/29/2021 |
| 3.0.7.42 | 3,124 | 3/15/2021 |
| 3.0.7.41 | 1,105 | 3/12/2021 |
| 3.0.7.40 | 1,131 | 3/12/2021 |
| 3.0.7.39 | 1,110 | 3/12/2021 |
| 3.0.7.38 | 1,132 | 3/12/2021 |
| 3.0.7.37 | 1,793 | 2/8/2021 |
| 3.0.7.36 | 885 | 2/4/2021 |
| 3.0.7.34 | 6,725 | 1/16/2021 |
| 3.0.7.33 | 3,870 | 1/12/2021 |
| 3.0.7.32 | 948 | 12/30/2020 |
| 3.0.7.31 | 880 | 12/29/2020 |
| 3.0.7.30 | 1,000 | 12/26/2020 |
| 3.0.7.28 | 3,056 | 12/23/2020 |
| 3.0.7.27 | 1,273 | 12/12/2020 |
| 3.0.7.26 | 1,075 | 11/27/2020 |
| 3.0.7.25 | 5,830 | 11/26/2020 |
| 3.0.7.24 | 1,663 | 11/25/2020 |
| 3.0.7.24-beta | 347 | 11/25/2020 |
| 3.0.7.23 | 3,758 | 11/4/2020 |
| 3.0.7.18 | 1,129 | 2/25/2021 |