DNLiCore_DB 1.1.1

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

// Install DNLiCore_DB as a Cake Tool
#tool nuget:?package=DNLiCore_DB&version=1.1.1

---介绍---
   注意:当前工具包为个人开发，正在不断的完善中,错误之处请多见谅。
DNLiCore_DB 是属于DNLiCore框架下的一个数据库工具类 SDK2.2,目标支持数据库类型包括 MySql,SqlServer,SqlLite
其中包括3种执行框架 Ado.net:SqlHelper,轻量级ORM:Petapoco,标准EF框架:EF Core
使用方法:1.安装 DNLiCore_DB
         2.在appsettings.json配置对应的数据库配置，例如
 "ConnectionStrings": {
                               "SqlServerConnection": "Server=******;Database=****;User ID=****;Password=*****;",
                               "MySqlConnection": "Database='*****';Data Source=****;User ID=****;Password=******.;CharSet=utf8;SslMode=None",
                               "SqlLiteConnection": "Data Source=ItcastCater.db"
                             }
         3.在Startup.cs进行注入，例如使用mysql数据库
   ①使用ado.net 注入方式
services.AddSingleton(typeof(DNLiCore_DB.IMySqlHelper), new DNLiCore_DB.MySqlHelper(Configuration.GetConnectionString("MySqlConnection")));
②使用petapoco 注入方式，
services.AddSingleton(typeof(DNLiCore_DB.IPetaPocoHelper), new DNLiCore_DB.PetaPocoHelper(Configuration.GetConnectionString("MySqlConnection"), 0));
③使用ef注入方式
 创建相应的DBContext和实体
 1.1 通过程序包管理控制台生成DBContext和实体输入,按需引用DNLiCore_DB
                  Scaffold-DbContext -Force  "Server=*****;User Id=****;Password=******;Database=drewtest" -Provider "Pomelo.EntityFrameworkCore.MySql"  
              注意:1.表必须要有主键
                   2.如果有需要只生成单表的加个 -Table 表名
               3.会存在datetime数据类型实体生成错误的情况，需要手动修改
 1.2 进行ef注入
services.AddSingleton(typeof(DNLiCore_DB.IRepository), new DNLiCore_DB.Repository(new DNLiCore_Model.drewtestContext()));
 4.在控制器构造函数注入使用，此方法不唯一，例如
 static DNLiCore_DB.IPetaPocoHelper mypetaPocoHelper;
 public HomeController(DNLiCore_DB.IPetaPocoHelper petaPocoHelper)
         {
           mypetaPocoHelper = petaPocoHelper;           
         }
 在其他方法中调用
 public IActionResult Index()
        {
var mylss = mypetaPocoHelper.Fetch(" select * from userInfo ");
}

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.2 is compatible.  netcoreapp3.0 was computed.  netcoreapp3.1 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.1.2 1,519 1/15/2019
1.1.1 1,427 1/7/2019
1.1.0 1,280 1/7/2019
1.0.9 1,467 12/27/2018
1.0.8 1,468 12/9/2018
1.0.7 1,652 12/9/2018
1.0.6 1,542 12/9/2018
1.0.5 1,481 12/7/2018
1.0.4 1,474 12/7/2018
1.0.3 1,399 12/7/2018
1.0.2 1,486 12/7/2018

Summary of changes made in this release of the package.