Flashcom.Util.DBUtility.MySQL 1.0.3

.NET Standard 2.0 This package targets .NET Standard 2.0. The package is compatible with this framework or higher.
There is a newer version of this package available.
See the version list below for details. 
dotnet add package Flashcom.Util.DBUtility.MySQL --version 1.0.3                

                    
                

            
NuGet\Install-Package Flashcom.Util.DBUtility.MySQL -Version 1.0.3
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="Flashcom.Util.DBUtility.MySQL" Version="1.0.3" />
For projects that support PackageReference, copy this XML node into the project file to reference the package. 
paket add Flashcom.Util.DBUtility.MySQL --version 1.0.3                

                    
                

            
#r "nuget: Flashcom.Util.DBUtility.MySQL, 1.0.3"
#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 Flashcom.Util.DBUtility.MySQL as a Cake Addin
#addin nuget:?package=Flashcom.Util.DBUtility.MySQL&version=1.0.3

// Install Flashcom.Util.DBUtility.MySQL as a Cake Tool
#tool nuget:?package=Flashcom.Util.DBUtility.MySQL&version=1.0.3

支持参数传入防注入 string sqlstr = "select * from user where user_id=@user_id;";

DBHelper db = new DBHelper(); var user = db.Query<User>(sqlstr, 1); SQL参数默认为@前缀，也可以以?前缀，但需要设置 UseQuestionMark = true;

支持读写分离，可同时支持多个只读库，查询会用只读，执行用主库，提供相关静态函数，先通知只读库查询，可通过其中条件判断是否为新数据（只读库可能会有同步时差，刚更新完立即查询会有问题），如果为旧数据会自动用主库进行查询

提供同步和异步方法

提供多种函数，返回DataSet，DataRow，dynamic(动态类)，T（指定类，支持属性别名） 支持SQL中包含变量，例如数据库名（[dbname]） 支持事务队列批量提交 和 事务模式，事务模式下支持 保存点，还原点等操作

1.0.3 增加简单ORM的支持，从SQL转换为类时，类的属性可以指定字段名（DBHelperTable，DBHelperColumn），支持直接用类插入（InsertORM）和更新（UpdateORM） 增加 分页的函数（QueryPaingExAsync，QueryPagingAsync） 事务队列的添加和执行支持线程安全，多线程可以同时添加事务队列和另线程提交事务队列

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 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

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
1.0.12 479 9/16/2021
1.0.11 398 8/18/2021
1.0.10 409 8/2/2021
1.0.9 503 7/11/2021
1.0.8 481 7/3/2021
1.0.7 490 6/25/2021
1.0.6 490 6/6/2021
1.0.5 478 5/25/2021
1.0.4 521 9/30/2020
1.0.3 606 9/23/2020
1.0.2 485 9/23/2020
1.0.1 471 9/22/2020
1.0.0 598 7/29/2020