Flashcom.Util.DBUtility.MySQL
1.0.3
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
<PackageReference Include="Flashcom.Util.DBUtility.MySQL" Version="1.0.3" />
paket add Flashcom.Util.DBUtility.MySQL --version 1.0.3
#r "nuget: Flashcom.Util.DBUtility.MySQL, 1.0.3"
// 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 | 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 | 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. |
-
.NETStandard 2.0
- Microsoft.Extensions.Logging (>= 3.1.6)
- MySql.Data (>= 8.0.21)
- Newtonsoft.Json (>= 12.0.3)
- sqlSugarCore (>= 5.0.0.15)
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.