YTKDBlibrary 1.0.1.23

dotnet add package YTKDBlibrary --version 1.0.1.23                
NuGet\Install-Package YTKDBlibrary -Version 1.0.1.23                
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="YTKDBlibrary" Version="1.0.1.23" />                
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add YTKDBlibrary --version 1.0.1.23                
#r "nuget: YTKDBlibrary, 1.0.1.23"                
#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 YTKDBlibrary as a Cake Addin
#addin nuget:?package=YTKDBlibrary&version=1.0.1.23

// Install YTKDBlibrary as a Cake Tool
#tool nuget:?package=YTKDBlibrary&version=1.0.1.23                

删除,支持查询条件 List<Model.modelTableQuery>
查询,支持sql语句 IopeExe.Select
执行,支持sql语句 IopeExe.Execute
插入,支持是否去重:如果存在可以不插入
初始化,支持modelDB一次性初始化模型 private modelDB DB = opeSqlDB.Init(modelTable, constring);
更新:支持条件 List<Model.modelTableQuery>
修改了部分 空值更新的问题

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.1.23 1,303 3/14/2022
1.0.1.22 1,215 3/11/2022
1.0.1.15 1,209 2/23/2022
1.0.1.14 1,224 2/23/2022
1.0.1.13 1,184 2/23/2022
1.0.1.12 1,275 2/23/2022
1.0.1.11 1,197 2/22/2022
1.0.1.10 1,283 2/22/2022
1.0.1.9 1,219 2/22/2022
1.0.1.8 1,296 2/10/2022
1.0.1.7 1,191 1/13/2022
1.0.1.6 1,127 1/12/2022
1.0.1.5 1,126 1/12/2022
1.0.1.3 1,178 11/8/2021
1.0.1.2 1,165 7/21/2020
1.0.1.1 1,225 7/16/2020
1.0.0.8 1,191 7/9/2020
1.0.0.6 1,278 7/8/2020
1.0.0.5 1,245 7/7/2020
1.0.0.4 1,261 6/24/2020
1.0.0.3 1,396 6/23/2020
1.0.0.2 1,453 6/23/2020
1.0.0.1 1,521 6/23/2020

////查询:包含 查询类型————————返回自定义模型
           //List<modelTableQuery> _query = new List<modelTableQuery>();
           //_query.Add(new modelTableQuery() { columName = _m.tableColum[0].columName, queryType = YTKDBlibrary.Enum.enmQueryType.equal, columValue = 7, columType = enmClumType.INT });
           ////创建分页对象
           //modelPage _page = new modelPage() { isPage = true, pageNum = 1, rowCount = 2 };
           ////创建排序条件
           //List<modelOrder> _order = new List<modelOrder>();
           //_order.Add(new modelOrder() { orderColum = _m.tableColum[0].columName, orderType = YTKDBlibrary.Enum.enmOrderType.DESC });
           //modelSqlObj ms = _sql.SelectCount(_query);


           ////查询总数—————————————指定条件
           //int count = _exe.SelectCount(ms);
           ////查询结果集合:tb_test 是表结构 模型 需要自己定义
           //List<tb_test> res = _exe.Select<tb_test>(_sql.Select(_query, _page, _order));
           //Console.ReadKey();


           ////查询:sql语句返回——————————返回自定义模型
           //List<tb_test> rrr = _exe.Select<tb_test>("select * from tb_test;", null);
           //Console.ReadKey();

           //// 插入————————————自定义模型
           //tb_test _ins = new tb_test() { pwd = "测试啊啊啊啊啊3啊测试啊啊啊啊dd啊啊啊" };
           //modelSqlObj sqlIns = _sql.Insert(new List<object>() { _ins }, true);
           //int id = _exe.Insert(sqlIns);
           //Console.ReadKey();


           ////更新—————————————指定条件
           ////数据库模型
           //tb_test _ups = new tb_test() { pwd = "aaaaaa", name = "yinlik" };
           ////指定条件
           //List<modelTableQuery> query = new List<modelTableQuery>() {
           //new modelTableQuery(){ columName="usrid",columType=enmClumType.INT,columValue=1},
           //new modelTableQuery(){ columName="pwd",columType=enmClumType.VARCHAR,columValue="密码"}
           //};
           //modelSqlObj sqlUpdate = _sql.Update(_ups, query);
           //_exe.Update(sqlUpdate);
           //Console.ReadKey();


           //删除————————————逻辑删除
           //modelDel mdlDel = new modelDel();
           //mdlDel.isLogic = true;
           //mdlDel.delColum = "country";
           //mdlDel.logicValue = 1;

           //删除————————————物理删除+条件
           //modelDelQurey mdlDeln = new modelDelQurey()
           //{
           //    isLogic = false
           //};
           //List<modelTableQuery> mdlDelq = new List<modelTableQuery>() {
           //new modelTableQuery(){
           //columValue=1,
           //columName="usrid",
           //columType=enmClumType.INT
           //}
           //};
           //modelSqlObj obj = _sql.Delete(mdlDeln,mdlDelq);
           //bool r = _exe.Delete(obj);
           //Console.ReadKey();