UN.QWPlatform.DBServiceCore 4.0.1.5

.NET Standard 2.1 This package targets .NET Standard 2.1. The package is compatible with this framework or higher. 
dotnet add package UN.QWPlatform.DBServiceCore --version 4.0.1.5                

                    
                

            
NuGet\Install-Package UN.QWPlatform.DBServiceCore -Version 4.0.1.5
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package. 
<PackageReference Include="UN.QWPlatform.DBServiceCore" Version="4.0.1.5" />
For projects that support PackageReference, copy this XML node into the project file to reference the package. 
paket add UN.QWPlatform.DBServiceCore --version 4.0.1.5                

                    
                

            
#r "nuget: UN.QWPlatform.DBServiceCore, 4.0.1.5"
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package. 
// Install UN.QWPlatform.DBServiceCore as a Cake Addin
#addin nuget:?package=UN.QWPlatform.DBServiceCore&version=4.0.1.5

// Install UN.QWPlatform.DBServiceCore as a Cake Tool
#tool nuget:?package=UN.QWPlatform.DBServiceCore&version=4.0.1.5

v4.0.1.5(why) 1.修正PG数据库批量更新问题： 1).事务未生效，默认已提交问题 2).更新的SQL脚本有问题（未识别到DBNull问题） 3).修改CUD获取参数为空处理 v4.0.1.4(why) 1.修正PG数据库时间写入带有时区信息时出错，强制转换时区为null v4.0.1.3(wy) 1.修正不支持Timespan插入PG数据库功能 2.升级Oracle的数据库驱动 v4.0.1.2(why) 1.修正PG批量更新问题 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 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. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

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.5 80 12/12/2024
4.0.1.2 99 11/26/2024

本次增加数据库参数的预编译功能