EaCloud.EntityFrameworkCore.SqlServer
9.0.0.9
dotnet add package EaCloud.EntityFrameworkCore.SqlServer --version 9.0.0.9
NuGet\Install-Package EaCloud.EntityFrameworkCore.SqlServer -Version 9.0.0.9
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="EaCloud.EntityFrameworkCore.SqlServer" Version="9.0.0.9" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
<PackageVersion Include="EaCloud.EntityFrameworkCore.SqlServer" Version="9.0.0.9" />
<PackageReference Include="EaCloud.EntityFrameworkCore.SqlServer" />
For projects that support Central Package Management (CPM), copy this XML node into the solution Directory.Packages.props file to version the package.
paket add EaCloud.EntityFrameworkCore.SqlServer --version 9.0.0.9
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: EaCloud.EntityFrameworkCore.SqlServer, 9.0.0.9"
#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.
#:package EaCloud.EntityFrameworkCore.SqlServer@9.0.0.9
#:package directive can be used in C# file-based apps starting in .NET 10 preview 4. Copy this into a .cs file before any lines of code to reference the package.
#addin nuget:?package=EaCloud.EntityFrameworkCore.SqlServer&version=9.0.0.9
#tool nuget:?package=EaCloud.EntityFrameworkCore.SqlServer&version=9.0.0.9
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
EaCloud SqlServer 数据库组件
说明
- EaCloud SqlServer 数据库组件,封装基于 Microsoft.EntityFrameworkCore.SqlServer 的数据访问功能的实现。
- 支持 SQL Server 2012 以上版本。
用法
可按照如下配置方式使用:
- 通过nuget引用
EaCloud.EntityFrameworkCore.SqlServer
程序集
Install-Package EaCloud.EntityFrameworkCore.SqlServer
- 在
appsettings.json
中的EaCloud
节点下添加如下配置节点
{
//数据库上下文集合
"DbContexts": {
//默认数据库上下文
"DefaultDbContext": {
"DbContextTypeName": "EaCloud.Entity.DefaultDbContext,EaCloud.EntityFrameworkCore", //上下文类型全名(默认数据库上下文)
"DatabaseType": "SqlServer", //数据库类型:"Cosmos"(Azure Cosmos DB 的 SQL API)、"Kdbndp"(人大金仓)、"MySql"、"Oracle"、"PostgreSql"、"Sqlite"、"SqlServer"
"ConnectionString": "Data Source=127.0.0.1;Initial Catalog=EaCloud_DEV;User ID=sa;Password=XXX;Pooling=true;Min Pool Size=1;Max Pool Size=60;Connect Timeout=60;Application Name=EaCloud;TrustServerCertificate=true;", //连接字符串(SqlServer)
//从数据库配置
"SlaveDatabase": {
"SlaveSelector": "Weight", //从数据库选择策略:Weight(平滑权重)、Random(随机)、Sequence(顺序轮询)
//从数据库集合
"SlaveDatabases": [
{
"Name": "Slave01", //数据库名
"Weight": 2, //权重(1-100)
"ConnectionString": "Data Source=127.0.0.1;Initial Catalog=EaCloud_DEV.Slave01;User ID=sa;Password=XXX;Pooling=true;Min Pool Size=1;Max Pool Size=60;Connect Timeout=60;Application Name=EaCloud;TrustServerCertificate=true;", //连接字符串(SqlServer)
},
{
"Name": "Slave02", //数据库名
"Weight": 5, //权重(1-100)
"ConnectionString": "Data Source=127.0.0.1;Initial Catalog=EaCloud_DEV.Slave02;User ID=sa;Password=XXX;Pooling=true;Min Pool Size=1;Max Pool Size=60;Connect Timeout=60;Application Name=EaCloud;TrustServerCertificate=true;", //连接字符串(SqlServer)
}
]
},
"CommandTimeout": 120, //命令执行超时时长(秒)
"IsolationLevel": null, //事务隔离级别:"Unspecified"、"Chaos"、"ReadUncommitted"、"ReadCommitted"、"RepeatableRead"、"Serializable"、"Snapshot"
"Compatibility": false, //启用兼容:开启后将使用旧版行为执行数据库操作已达到可使用较低版本数据库的目的。注:开启后不会使用更高效的SQL生成逻辑,可能会削弱性能。
"LazyLoadingProxiesEnabled": false, //是否启用延迟加载代理
"DateTimeUtcFormatEnabled": false, //是否启用时间UTC格式
"EntityAuditEnabled": true, //是否启用数据审计
"EntityEventEnabled": true, //是否启用数据事件
"MigrationAssemblyName": "[Your Migration Assembly Name]", //迁移的程序集名称(为空时默认"DesignTime[Your Name]DbContextFactory"所在程序集),PS:Cosmos暂不支持
"MigrationEnabled": true //启用自动迁移,PS:Cosmos暂不支持
}
},
}
交流
![]() |
![]() |
---|---|
QQ群号:863605868 | 微信号:SeonHu |
Product | Versions Compatible and additional computed target framework versions. |
---|---|
.NET | net9.0 is compatible. net9.0-android was computed. net9.0-browser was computed. net9.0-ios was computed. net9.0-maccatalyst was computed. net9.0-macos was computed. net9.0-tvos was computed. net9.0-windows was computed. net10.0 was computed. net10.0-android was computed. net10.0-browser was computed. net10.0-ios was computed. net10.0-maccatalyst was computed. net10.0-macos was computed. net10.0-tvos was computed. net10.0-windows was computed. |
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.
-
net9.0
- EaCloud.EntityFrameworkCore (>= 9.0.0.9)
- Microsoft.EntityFrameworkCore.SqlServer (>= 9.0.8)
NuGet packages (1)
Showing the top 1 NuGet packages that depend on EaCloud.EntityFrameworkCore.SqlServer:
Package | Downloads |
---|---|
EaCloud.EntityFrameworkCore.Allinone
EaCloud 一体化数据访问组件,封装 Cosmos(Azure Cosmos DB 的 SQL API)、Kdbndp(人大金仓)、MySql、Oracle、PostgreSql、SAP HANA、Sqlite、SqlServer 等类型数据访问功能的实现。 |
GitHub repositories
This package is not used by any popular GitHub repositories.
Version | Downloads | Last Updated |
---|---|---|
9.0.0.9 | 144 | 8/12/2025 |
9.0.0.8 | 94 | 7/5/2025 |
9.0.0.7 | 169 | 6/25/2025 |
9.0.0.6 | 175 | 6/18/2025 |
9.0.0.5 | 173 | 6/14/2025 |
9.0.0.4 | 193 | 5/8/2025 |
9.0.0.3 | 188 | 4/23/2025 |
9.0.0.2 | 202 | 4/11/2025 |
9.0.0.1 | 176 | 3/21/2025 |
8.0.1.9 | 177 | 11/15/2024 |
8.0.1.8 | 163 | 11/13/2024 |
8.0.1.7 | 176 | 10/9/2024 |
8.0.1.6 | 169 | 9/29/2024 |
8.0.1.5 | 166 | 9/13/2024 |
8.0.1.4 | 196 | 8/10/2024 |
8.0.1.3 | 180 | 8/7/2024 |
8.0.1.2 | 174 | 8/7/2024 |
8.0.1.1 | 180 | 8/7/2024 |
8.0.0.9 | 183 | 8/7/2024 |
8.0.0.8 | 124 | 8/5/2024 |
8.0.0.7 | 136 | 8/2/2024 |
8.0.0.6 | 142 | 8/1/2024 |
8.0.0.5 | 143 | 8/1/2024 |
8.0.0.4 | 126 | 7/31/2024 |
8.0.0.3 | 143 | 7/30/2024 |
8.0.0.2 | 164 | 7/25/2024 |
8.0.0.1 | 143 | 7/24/2024 |
7.0.9.4 | 186 | 7/19/2024 |
7.0.9.3 | 163 | 7/11/2024 |
7.0.9.2 | 164 | 7/6/2024 |
7.0.9.1 | 150 | 7/3/2024 |
7.0.8.9 | 161 | 6/28/2024 |
7.0.8.8 | 164 | 6/26/2024 |
7.0.8.7 | 166 | 6/22/2024 |
7.0.8.6 | 163 | 6/14/2024 |
7.0.8.5 | 182 | 5/31/2024 |
7.0.8.4 | 173 | 5/21/2024 |
7.0.8.3 | 160 | 5/21/2024 |
7.0.8.2 | 152 | 5/20/2024 |
7.0.8.1 | 162 | 5/20/2024 |
7.0.7.9 | 159 | 5/15/2024 |
7.0.7.8 | 164 | 5/10/2024 |
7.0.7.7 | 155 | 5/9/2024 |
7.0.7.6 | 155 | 5/9/2024 |
7.0.7.5 | 170 | 5/7/2024 |
7.0.7.4 | 168 | 4/28/2024 |
7.0.7.3 | 165 | 4/26/2024 |
7.0.7.2 | 170 | 4/21/2024 |
7.0.7.1 | 167 | 4/19/2024 |
7.0.6.9 | 174 | 4/15/2024 |
7.0.6.8 | 148 | 4/11/2024 |
7.0.6.7 | 172 | 4/11/2024 |
7.0.6.6 | 163 | 4/7/2024 |
7.0.6.5 | 159 | 4/7/2024 |
7.0.6.4 | 176 | 4/7/2024 |
7.0.6.3 | 162 | 4/7/2024 |
7.0.6.2 | 173 | 4/3/2024 |
7.0.6.1 | 175 | 4/3/2024 |
7.0.5.9 | 176 | 3/27/2024 |
7.0.5.8 | 159 | 3/23/2024 |
7.0.5.7 | 192 | 3/17/2024 |
7.0.5.6 | 173 | 3/17/2024 |
7.0.5.5 | 169 | 3/16/2024 |
7.0.5.4 | 172 | 3/13/2024 |
7.0.5.3 | 168 | 3/13/2024 |
7.0.5.2 | 189 | 3/6/2024 |
7.0.5.1 | 169 | 2/21/2024 |
7.0.4.9 | 172 | 2/21/2024 |
7.0.4.8 | 176 | 2/18/2024 |
7.0.4.7 | 179 | 2/5/2024 |
7.0.4.6 | 172 | 2/1/2024 |
7.0.4.5 | 168 | 1/26/2024 |
7.0.4.4 | 170 | 1/22/2024 |
7.0.4.3 | 185 | 1/17/2024 |
7.0.4.2 | 182 | 1/16/2024 |
7.0.4.1 | 165 | 1/16/2024 |
7.0.3.9 | 161 | 1/15/2024 |
7.0.3.8 | 197 | 1/3/2024 |
7.0.3.7 | 175 | 12/28/2023 |
7.0.3.6 | 162 | 12/27/2023 |
7.0.3.5 | 193 | 12/22/2023 |
7.0.3.4 | 176 | 12/22/2023 |
7.0.3.3 | 195 | 12/13/2023 |
7.0.3.2 | 161 | 12/13/2023 |
7.0.3.1 | 190 | 12/12/2023 |
7.0.2.9 | 178 | 11/26/2023 |
7.0.2.8 | 160 | 11/26/2023 |
7.0.2.7 | 193 | 9/26/2023 |
7.0.2.6 | 179 | 9/25/2023 |
7.0.2.5 | 192 | 9/15/2023 |
7.0.2.4 | 190 | 7/27/2023 |
7.0.2.3 | 218 | 7/22/2023 |
7.0.2.2 | 224 | 7/22/2023 |
7.0.2.1 | 234 | 7/21/2023 |
7.0.1.9 | 221 | 7/21/2023 |
7.0.1.8 | 212 | 7/20/2023 |
7.0.1.7 | 218 | 7/20/2023 |
7.0.1.6 | 234 | 7/4/2023 |
7.0.1.5 | 206 | 6/16/2023 |
7.0.1.4 | 203 | 6/13/2023 |
7.0.1.3 | 198 | 6/8/2023 |
7.0.1.2 | 194 | 6/2/2023 |
7.0.1.1 | 218 | 5/11/2023 |
7.0.0.9 | 198 | 5/10/2023 |
7.0.0.8 | 203 | 5/10/2023 |
7.0.0.7 | 271 | 4/19/2023 |
7.0.0.6 | 230 | 4/18/2023 |
7.0.0.5 | 287 | 3/27/2023 |
7.0.0.4 | 267 | 3/23/2023 |
7.0.0.3 | 334 | 1/31/2023 |
7.0.0.2 | 321 | 1/30/2023 |
7.0.0.1 | 336 | 12/24/2022 |
6.0.2.5 | 379 | 11/16/2022 |
6.0.2.4 | 402 | 11/10/2022 |
6.0.2.3 | 449 | 10/11/2022 |
6.0.2.2 | 521 | 9/23/2022 |
6.0.2.1 | 539 | 8/14/2022 |
6.0.1.9 | 540 | 8/13/2022 |
6.0.1.8 | 551 | 6/6/2022 |
6.0.1.7 | 578 | 5/26/2022 |
6.0.1.6 | 604 | 5/11/2022 |
6.0.1.5 | 563 | 5/10/2022 |
6.0.1.4 | 605 | 4/8/2022 |
6.0.1.3 | 600 | 4/2/2022 |
6.0.1.2 | 612 | 4/2/2022 |
6.0.1.1 | 623 | 3/18/2022 |
6.0.0.9 | 618 | 3/5/2022 |
6.0.0.8 | 628 | 2/19/2022 |
6.0.0.7 | 632 | 2/15/2022 |
6.0.0.6 | 633 | 2/14/2022 |
6.0.0.5 | 666 | 1/28/2022 |
6.0.0.4 | 550 | 1/13/2022 |
6.0.0.3 | 540 | 1/12/2022 |
6.0.0.2 | 384 | 12/21/2021 |
6.0.0.1 | 390 | 12/13/2021 |
5.0.3.7 | 555 | 10/16/2021 |
5.0.3.6 | 484 | 10/14/2021 |
5.0.3.5 | 457 | 10/13/2021 |
5.0.3.4 | 490 | 10/8/2021 |
5.0.3.3 | 470 | 9/17/2021 |
5.0.3.2 | 510 | 9/16/2021 |
5.0.3.1 | 461 | 9/15/2021 |
5.0.2.9 | 513 | 9/15/2021 |
5.0.2.8 | 476 | 8/31/2021 |
5.0.2.7 | 491 | 8/28/2021 |
5.0.2.6 | 470 | 8/22/2021 |
5.0.2.5 | 464 | 8/13/2021 |
5.0.2.4 | 409 | 8/13/2021 |
5.0.2.3 | 519 | 7/8/2021 |
5.0.2.2 | 479 | 7/1/2021 |
5.0.2.1 | 560 | 6/16/2021 |
5.0.1.9 | 466 | 5/12/2021 |
5.0.1.8 | 475 | 5/9/2021 |
5.0.1.7 | 513 | 5/7/2021 |
5.0.1.6 | 515 | 4/17/2021 |
5.0.1.5 | 450 | 4/16/2021 |
5.0.1.4 | 519 | 4/15/2021 |
5.0.1.3 | 455 | 4/15/2021 |
5.0.1.2 | 500 | 4/12/2021 |