DNLiCore_DB 1.1.0

.NET Core 2.2 This package targets .NET Core 2.2. 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 DNLiCore_DB --version 1.1.0                

                    
                

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

                    
                

            
#r "nuget: DNLiCore_DB, 1.1.0"
#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.0

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

---介绍---
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,569 1/15/2019
1.1.1 1,461 1/7/2019
1.1.0 1,305 1/7/2019
1.0.9 1,506 12/27/2018
1.0.8 1,502 12/9/2018
1.0.7 1,690 12/9/2018
1.0.6 1,576 12/9/2018
1.0.5 1,509 12/7/2018
1.0.4 1,503 12/7/2018
1.0.3 1,429 12/7/2018
1.0.2 1,517 12/7/2018

Summary of changes made in this release of the package.