ToolNET.Dapper 5.0.1

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

// Install ToolNET.Dapper as a Cake Tool
#tool nuget:?package=ToolNET.Dapper&version=5.0.1                

1.配置文件格式:

{
  "Dapper": {
    "WriteConnectionString": "server=.;database=DapperSnookerDev;uid=sa;pwd=123456789;",    //读写库连接字符串
    "ReadOnlyConnectionStrings": [                                                          //只读库配置
      {
        "ConnectionString": "server=.;database=DapperSnookerDev;uid=sa;pwd=123456789;",     //只读库连接字符串
        "Weight": 1                                                                         //权重
      }
    ]
  }
}

2.默认配置

默认配置:

文件路径 文件名称 节点名称
应用根目录 appsettings.json Dapper

不使用默认的配置节点或文件时,需要在程序入口调用以下扩展方法,指定配置文件:

DapperInjection.UseDapper(this IHostBuilder builder, string fileName, string key = "", string fileDir = null)
builder.UseDapper(fileName:"", key :"", fileDir:"");

3.方法调用

工具类名 说明
ViewSet 读数据
TableSet 读写数据
DapperDbContext 读写数据

4.其他事项说明

事项 说明
申明连接池 hostBuilder.AddDapperConnection<SqlConnection>();
依赖注入------单例 services.AddDapperDbContext(new DefaultDbContext());
依赖注入------作用域 services.AddDapperDbContextScoped(new DefaultDbContext());
依赖注入------单例 services.AddDapperTableSet(new TableSet<T>());
依赖注入------作用域 services.AddDapperTableSetScoped(new TableSet<T>());
依赖注入------单例 services.AddDapperViewSet(new ViewSet<T>());
依赖注入------作用域 services.AddDapperViewSetScoped(new ViewSet<T>());
Dapper字段映射 hostBuilder.UseDapperColumnMap("Models","DTO");
Product Compatible and additional computed target framework versions.
.NET net5.0 is compatible.  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. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

NuGet packages (1)

Showing the top 1 NuGet packages that depend on ToolNET.Dapper:

Package Downloads
ToolNET.Dapper.Shard

Dapper/ORM 分表

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last updated
5.1.1 290 3/15/2023
5.1.0 320 12/9/2022
5.0.6 444 9/7/2022
5.0.5 440 8/31/2022
5.0.4 424 8/30/2022
5.0.3 444 8/30/2022
5.0.2 428 8/26/2022
5.0.1 661 3/17/2022
5.0.0 629 3/16/2022