YTKDBlibrary 1.0.1.23
dotnet add package YTKDBlibrary --version 1.0.1.23
NuGet\Install-Package YTKDBlibrary -Version 1.0.1.23
<PackageReference Include="YTKDBlibrary" Version="1.0.1.23" />
paket add YTKDBlibrary --version 1.0.1.23
#r "nuget: YTKDBlibrary, 1.0.1.23"
// 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 | 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
- MySql.Data (>= 8.0.20)
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();