ToolNET.SqlSugar
5.0.2
There is a newer version of this package available.
See the version list below for details.
See the version list below for details.
dotnet add package ToolNET.SqlSugar --version 5.0.2
NuGet\Install-Package ToolNET.SqlSugar -Version 5.0.2
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.SqlSugar" Version="5.0.2" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add ToolNET.SqlSugar --version 5.0.2
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: ToolNET.SqlSugar, 5.0.2"
#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.SqlSugar as a Cake Addin #addin nuget:?package=ToolNET.SqlSugar&version=5.0.2 // Install ToolNET.SqlSugar as a Cake Tool #tool nuget:?package=ToolNET.SqlSugar&version=5.0.2
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
1.配置文件格式：
{
"SqlSugar": {
"DbType": "SqlServer", //数据库类型 支持的数据库：请参阅SqlSugar官网
"WriteConnectionString": "", //读写库连接字符串
"ReadOnlyConnectionStrings": [ //只读库配置
{
"ConnectionString": "", //只读库连接字符串
"Weight": 1 //权重
}
]
}
}
2.默认配置
默认配置：
| 文件路径 | 文件名称 | 节点名称 |
|---|---|---|
| 应用根目录 | appsettings.json | SqlSugar |
不使用默认的配置节点或文件时,需要在程序入口调用以下扩展方法,指定配置文件：
SqlSugarInjection.UseSqlSugar(this IHostBuilder builder, string fileName, string key = "", string fileDir = null);
builder.UseSqlSugar(fileName:"", key :"", fileDir:"");
3.方法调用
| 工具类名 | 说明 |
|---|---|
| SqlSugarUtils | 读写数据 |
| SqlSugarRepository | 读写数据 |
| SqlSugarDbContext | 读写数据 |
| SqlSugarRepository | 读写数据,仅针对单表 |
4.其他事项说明
| 事项 | 说明 |
|---|---|
| 依赖注入--Singleton | services.AddSqlSugarScope(); |
| 依赖注入--Scoped | services.AddSqlSugarClient(); |
| 依赖注入--Singleton | services.AddSqlSugarDbContextSingleton(new SqlSugarSqlServerDbContext()); |
| 依赖注入--Scoped | services.AddSqlSugarDbContextScoped(new SqlSugarSqlServerDbContext()); |
| 依赖注入--Singleton | services.AddSqlSugarRepositorySingleton(new SqlSugarRepository<T>()); |
| 依赖注入--Scoped | services.AddSqlSugarRepositoryScoped(new SqlSugarRepository<T>()); |
| Product | Versions 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.
-
net5.0
- SqlSugarCore (>= 5.0.5.2)
- ToolNET.Infrastructure.Algorithm (>= 5.0.0)
- ToolNET.Infrastructure.Config (>= 5.0.0)
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.