UN.QWPlatform.DBServiceCore
4.0.1.2
dotnet add package UN.QWPlatform.DBServiceCore --version 4.0.1.2
NuGet\Install-Package UN.QWPlatform.DBServiceCore -Version 4.0.1.2
<PackageReference Include="UN.QWPlatform.DBServiceCore" Version="4.0.1.2" />
paket add UN.QWPlatform.DBServiceCore --version 4.0.1.2
#r "nuget: UN.QWPlatform.DBServiceCore, 4.0.1.2"
// Install UN.QWPlatform.DBServiceCore as a Cake Addin #addin nuget:?package=UN.QWPlatform.DBServiceCore&version=4.0.1.2 // Install UN.QWPlatform.DBServiceCore as a Cake Tool #tool nuget:?package=UN.QWPlatform.DBServiceCore&version=4.0.1.2
v4.0.1.2(why) 1.批量更新修改 v4.0.1.1(why) 1.数据参数增加预编译功能 v4.0.1.0(why) 1.将所有驱动升级到较新的dll
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.20739)
- MySql.Data (>= 8.3.0)
- Npgsql (>= 8.0.4)
- Oracle.ManagedDataAccess.Core (>= 23.3.3-dev)
- System.Data.SqlClient (>= 4.8.6)
- System.Data.SQLite (>= 1.0.118)
- UN.QWPlatform.SystemLibraryCore (>= 4.0.1.2)
NuGet packages (1)
Showing the top 1 NuGet packages that depend on UN.QWPlatform.DBServiceCore:
Package | Downloads |
---|---|
UN.QWPlatform.WebBasics
Web业务域公共dll 20241122 增加移动端API分组枚举值 |
GitHub repositories
This package is not used by any popular GitHub repositories.
Version | Downloads | Last updated |
---|---|---|
4.0.1.2 | 46 | 11/26/2024 |
本次增加数据库参数的预编译功能