Oscar.Data.SqlClient 4.2.0

There is a newer version of this package available.
See the version list below for details.
dotnet add package Oscar.Data.SqlClient --version 4.2.0
NuGet\Install-Package Oscar.Data.SqlClient -Version 4.2.0
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="Oscar.Data.SqlClient" Version="4.2.0" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add Oscar.Data.SqlClient --version 4.2.0
#r "nuget: Oscar.Data.SqlClient, 4.2.0"
#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 Oscar.Data.SqlClient as a Cake Addin
#addin nuget:?package=Oscar.Data.SqlClient&version=4.2.0

// Install Oscar.Data.SqlClient as a Cake Tool
#tool nuget:?package=Oscar.Data.SqlClient&version=4.2.0

版本 v4.2.0

新增功能

  1. req #119961 : 添加耗时日志记录器, 记录连接建立后到执行过程耗时和堆栈信息,用于诊断和分析执行问题 使用方式:连接字符串中配置日志等级 LOGLEVEL = 7 或者 使用配置参数 DIAGNOSIS或DIAGNOSTIC或DIAGNOSISENABLED或DIAGNOSTICENABLED = true 强制开启耗时诊断记录。

  2. req #122787 : 支持设置日志文件的文件名称和存放目录路径,支持限制日志文件大小和按日期记录。

日志文件设计方案:

配置:

  • 设置LOG日志级别 关键词 LOGLEVEL 默认值 3(ERROR)

  • 设置LOG文件目录路径 关键词 LOGDIR LOGDIRPATH LOGDIRECTORY LOGDIRECTORYPATH 默认值(当前项目根目录下logs)

  • 设置LOG文件默认名称 关键词 LOGFILE LOGFILENAME 默认值 (oscar_log)

  • 设置LOG文件默认扩展名称 关键词 LOGEXT LOGFILEEXT LOGEXTNAME LOGFILEEXTENSIONNAME 默认值(txt)

  • 设置LOG文件默认记录的最大数量 关键词 LOGFILEMAXSIZE 默认值 (100000条记录 大约10M)

生成日志规则:

  • 日志文件路径格式 {日志存放目录}/{文件名称}{日期}{编号}.{文件扩展名}
  • 每天生成一个新日志文件
  • 对于每个日志文件, 记录日志数量不超过允许的最大数量(LOGFILEMAXSIZE),超过文件记录最大数量, 自动切换下一个日志文件,如 oscar_log_20230425_01.txt 切换 oscar_log_20230425_02.txt....
  1. req #122787 : 优化配置文件策略, 支持通过配置文件 oscarconfig.ini 配置驱动配置信息 配置文件的读取优先顺序:从当前项目下去读 oscarconfig.ini,如果没有找到文件, 再从环境变量 SZ_OSCAR_HOME 的目录下去找配置文件.

修复BUG

  1. bug #123022 : 修复兼容旧数据库执行匿名块时绑定参数传NULL执行失败和 Command 不能重复执行的问题
  2. bug #119960 : 解决执行计划释放问题
  3. bug #122899 : 兼容驱动支持旧版数据库匿名块功能
  4. bug #122840 : 未将对象引用设置到对象的实例
  5. bug #117872 : 日志优化
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 netcoreapp2.0 was computed.  netcoreapp2.1 was computed.  netcoreapp2.2 was computed.  netcoreapp3.0 was computed.  netcoreapp3.1 was computed. 
.NET Standard netstandard2.0 is compatible.  netstandard2.1 was computed. 
.NET Framework net20 is compatible.  net35 was computed.  net40 was computed.  net403 was computed.  net45 was computed.  net451 was computed.  net452 was computed.  net46 was computed.  net461 was computed.  net462 was computed.  net463 was computed.  net47 was computed.  net471 was computed.  net472 was computed.  net48 was computed.  net481 was computed. 
MonoAndroid monoandroid was computed. 
MonoMac monomac was computed. 
MonoTouch monotouch was computed. 
Tizen tizen40 was computed.  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 (24)

Showing the top 5 NuGet packages that depend on Oscar.Data.SqlClient:

Package Downloads
SqlSugarCore

.Net Core3.1 .Net5 .Net6 .Net7 .Net8 安装此版本,好用的ORM框架 ,支持国外主流和国产人大金仓达梦 OceanBase GaussDB QuestDb ClickHouse Oracle MySql Gbase8s SqlServer Sqlite 等, 使用教程:https://www.donet5.com/Home/Doc?typeId=1226

FreeSql.Provider.ShenTong

FreeSql 数据库实现,基于 神舟通用数据库 7.0.8

learun.database

力软ORM

ShenTong.EntityFrameworkCore.Oscar

神通数据库ORM EntityFrameworkCore .NET Standard2.0(TFM)支持.NET Framework >=4.6.1 以及 .NET Core 2.0 至 .NET 5(最新)

BimTech.SqlSugar

基于SqlSugar5.0.9.1 定制

GitHub repositories (2)

Showing the top 2 popular GitHub repositories that depend on Oscar.Data.SqlClient:

Repository Stars
DotNetNext/SqlSugar
.Net aot ORM Fastest ORM Simple Easy VB.NET Sqlite orm Oracle ORM Mysql Orm postgresql ORm SqlServer oRm 达梦 ORM 人大金仓 ORM 神通ORM C# ORM , C# ORM .NET ORM NET5 ORM .NET6 ORM ClickHouse orm QuestDb ,TDengine ORM,OceanBase orm,GaussDB orm ,Tidb orm Object/Relational Mapping
dotnetcore/FreeSql
🦄 .NET aot orm, C# orm, VB.NET orm, Mysql orm, Postgresql orm, SqlServer orm, Oracle orm, Sqlite orm, Firebird orm, 达梦 orm, 人大金仓 orm, 神通 orm, 翰高 orm, 南大通用 orm, 虚谷 orm, 国产 orm, Clickhouse orm, QuestDB orm, MsAccess orm.
Version Downloads Last updated
4.2.6 1,287 12/11/2023
4.2.5 642 11/2/2023
4.2.3 2,767 6/14/2023
4.2.0 2,676 5/8/2023
4.1.2 2,034 10/28/2022
4.1.0 3,824 6/10/2022
4.0.6 1,199 12/7/2021
4.0.5 23,663 9/29/2021
4.0.4 39,058 8/3/2021
4.0.3 763 7/28/2021
4.0.2 711 7/28/2021
1.0.8.5 987 5/11/2021
1.0.8.4 693 4/22/2021
1.0.8.2 20,220 1/21/2021
1.0.8.1 1,080 1/15/2021
1.0.8 878 1/15/2021
1.0.7.1 801 12/7/2020
1.0.7 980 12/4/2020
1.0.6.1 809 11/29/2020