EaCloud.EntityFrameworkCore.SqlServer
7.0.1.1
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 EaCloud.EntityFrameworkCore.SqlServer --version 7.0.1.1
NuGet\Install-Package EaCloud.EntityFrameworkCore.SqlServer -Version 7.0.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="EaCloud.EntityFrameworkCore.SqlServer" Version="7.0.1.1" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add EaCloud.EntityFrameworkCore.SqlServer --version 7.0.1.1
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: EaCloud.EntityFrameworkCore.SqlServer, 7.0.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 EaCloud.EntityFrameworkCore.SqlServer as a Cake Addin #addin nuget:?package=EaCloud.EntityFrameworkCore.SqlServer&version=7.0.1.1 // Install EaCloud.EntityFrameworkCore.SqlServer as a Cake Tool #tool nuget:?package=EaCloud.EntityFrameworkCore.SqlServer&version=7.0.1.1
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 2. 在
appsettings.json
中 的EaCloud
节点下添加如下配置节点
{
//数据库上下文
"DbContexts": {
//数据库类型节点:"Cosmos":{},"MySql":{},"Oracle":{},"PostgreSql":{},"Sqlite":{},"SqlServer":{}
"SqlServer": {
"DbContextTypeName": "EaCloud.Entity.DefaultDbContext,EaCloud.EntityFrameworkCore", //上下文类型全名(此项不需要调整)
"DatabaseType": "SqlServer", //数据库类型:"Cosmos"、"MySql"、"Oracle"、"PostgreSql"、"Sqlite"、"SqlServer"
"DatabaseName": "EaCloud_DEV", //数据库名
"ConnectionString": "Data Source=IP地址;Initial Catalog=数据库名;User ID=数据库身份验证ID;Password=密码;Pooling=true(是否汇入连接池);Min Pool Size=1(最小连接池连接数);Max Pool Size=20(最大连接数);Integrated Security=true(false:用户名密码验证、true:windows身份验证);Multiple Active Result Sets=true(是否允许保留多活动结果集(MARS));Connect Timeout=60(连接超时时长(秒));Application Name=应用程序名称", //连接字符串(SqlServer)
//从数据库配置
"SlaveDatabase": {
"SlaveSelector": "Weight", //从数据库选择策略:Weight(平滑权重)、Random(随机)、Sequence(顺序轮询)
//从数据库集合
"SlaveDatabases": [
{
"Name": "EaCloud_DEV_Slave01", //数据库名
"Weight": 2, //权重(1-100)
"ConnectionString": "Data Source=IP地址;Initial Catalog=数据库名;User ID=数据库身份验证ID;Password=密码;Pooling=true(是否汇入连接池);Min Pool Size=1(最小连接池连接数);Max Pool Size=20(最大连接数);Integrated Security=true(false:用户名密码验证、true:windows身份验证);Multiple Active Result Sets=true(是否允许保留多活动结果集(MARS));Connect Timeout=60(连接超时时长(秒));Application Name=应用程序名称", //连接字符串(SqlServer)
},
{
"Name": "EaCloud_DEV_Slave02", //数据库名
"Weight": 5, //权重(1-100)
"ConnectionString": "Data Source=IP地址;Initial Catalog=数据库名;User ID=数据库身份验证ID;Password=密码;Pooling=true(是否汇入连接池);Min Pool Size=1(最小连接池连接数);Max Pool Size=20(最大连接数);Integrated Security=true(false:用户名密码验证、true:windows身份验证);Multiple Active Result Sets=true(是否允许保留多活动结果集(MARS));Connect Timeout=60(连接超时时长(秒));Application Name=应用程序名称", //连接字符串(SqlServer)
}
]
},
"LazyLoadingProxiesEnabled": true, //是否启用延迟加载代理
"DateTimeUtcFormatEnabled": false, //是否启用时间UTC格式
"AuditEntityEnabled": true, //是否允许审计实体
"AutoMigrationEnabled": true //是否自动迁移
}
},
}
Product | Versions Compatible and additional computed target framework versions. |
---|---|
.NET | net7.0 is compatible. 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.
-
net7.0
- EaCloud.EntityFrameworkCore (>= 7.0.1.1)
- Microsoft.EntityFrameworkCore.SqlServer (>= 7.0.5)
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 |
---|---|---|
8.0.1.7 | 122 | 10/9/2024 |
8.0.1.6 | 114 | 9/29/2024 |
8.0.1.5 | 116 | 9/13/2024 |
8.0.1.4 | 149 | 8/10/2024 |
8.0.1.3 | 119 | 8/7/2024 |
8.0.1.2 | 119 | 8/7/2024 |
8.0.1.1 | 128 | 8/7/2024 |
8.0.0.9 | 132 | 8/7/2024 |
8.0.0.8 | 80 | 8/5/2024 |
8.0.0.7 | 83 | 8/2/2024 |
8.0.0.6 | 95 | 8/1/2024 |
8.0.0.5 | 92 | 8/1/2024 |
8.0.0.4 | 79 | 7/31/2024 |
8.0.0.3 | 92 | 7/30/2024 |
8.0.0.2 | 117 | 7/25/2024 |
8.0.0.1 | 96 | 7/24/2024 |
7.0.9.4 | 136 | 7/19/2024 |
7.0.9.3 | 113 | 7/11/2024 |
7.0.9.2 | 110 | 7/6/2024 |
7.0.9.1 | 104 | 7/3/2024 |
7.0.8.9 | 113 | 6/28/2024 |
7.0.8.8 | 116 | 6/26/2024 |
7.0.8.7 | 119 | 6/22/2024 |
7.0.8.6 | 116 | 6/14/2024 |
7.0.8.5 | 130 | 5/31/2024 |
7.0.8.4 | 128 | 5/21/2024 |
7.0.8.3 | 116 | 5/21/2024 |
7.0.8.2 | 103 | 5/20/2024 |
7.0.8.1 | 116 | 5/20/2024 |
7.0.7.9 | 112 | 5/15/2024 |
7.0.7.8 | 113 | 5/10/2024 |
7.0.7.7 | 108 | 5/9/2024 |
7.0.7.6 | 108 | 5/9/2024 |
7.0.7.5 | 122 | 5/7/2024 |
7.0.7.4 | 117 | 4/28/2024 |
7.0.7.3 | 123 | 4/26/2024 |
7.0.7.2 | 126 | 4/21/2024 |
7.0.7.1 | 124 | 4/19/2024 |
7.0.6.9 | 127 | 4/15/2024 |
7.0.6.8 | 105 | 4/11/2024 |
7.0.6.7 | 128 | 4/11/2024 |
7.0.6.6 | 118 | 4/7/2024 |
7.0.6.5 | 114 | 4/7/2024 |
7.0.6.4 | 129 | 4/7/2024 |
7.0.6.3 | 118 | 4/7/2024 |
7.0.6.2 | 127 | 4/3/2024 |
7.0.6.1 | 126 | 4/3/2024 |
7.0.5.9 | 131 | 3/27/2024 |
7.0.5.8 | 110 | 3/23/2024 |
7.0.5.7 | 148 | 3/17/2024 |
7.0.5.6 | 126 | 3/17/2024 |
7.0.5.5 | 130 | 3/16/2024 |
7.0.5.4 | 125 | 3/13/2024 |
7.0.5.3 | 124 | 3/13/2024 |
7.0.5.2 | 146 | 3/6/2024 |
7.0.5.1 | 125 | 2/21/2024 |
7.0.4.9 | 126 | 2/21/2024 |
7.0.4.8 | 127 | 2/18/2024 |
7.0.4.7 | 138 | 2/5/2024 |
7.0.4.6 | 129 | 2/1/2024 |
7.0.4.5 | 128 | 1/26/2024 |
7.0.4.4 | 125 | 1/22/2024 |
7.0.4.3 | 140 | 1/17/2024 |
7.0.4.2 | 142 | 1/16/2024 |
7.0.4.1 | 117 | 1/16/2024 |
7.0.3.9 | 116 | 1/15/2024 |
7.0.3.8 | 156 | 1/3/2024 |
7.0.3.7 | 136 | 12/28/2023 |
7.0.3.6 | 123 | 12/27/2023 |
7.0.3.5 | 154 | 12/22/2023 |
7.0.3.4 | 133 | 12/22/2023 |
7.0.3.3 | 151 | 12/13/2023 |
7.0.3.2 | 121 | 12/13/2023 |
7.0.3.1 | 148 | 12/12/2023 |
7.0.2.9 | 151 | 11/26/2023 |
7.0.2.8 | 137 | 11/26/2023 |
7.0.2.7 | 157 | 9/26/2023 |
7.0.2.6 | 147 | 9/25/2023 |
7.0.2.5 | 157 | 9/15/2023 |
7.0.2.4 | 145 | 7/27/2023 |
7.0.2.3 | 168 | 7/22/2023 |
7.0.2.2 | 176 | 7/22/2023 |
7.0.2.1 | 185 | 7/21/2023 |
7.0.1.9 | 169 | 7/21/2023 |
7.0.1.8 | 165 | 7/20/2023 |
7.0.1.7 | 169 | 7/20/2023 |
7.0.1.6 | 186 | 7/4/2023 |
7.0.1.5 | 152 | 6/16/2023 |
7.0.1.4 | 144 | 6/13/2023 |
7.0.1.3 | 143 | 6/8/2023 |
7.0.1.2 | 137 | 6/2/2023 |
7.0.1.1 | 156 | 5/11/2023 |
7.0.0.9 | 138 | 5/10/2023 |
7.0.0.8 | 144 | 5/10/2023 |
7.0.0.7 | 208 | 4/19/2023 |
7.0.0.6 | 171 | 4/18/2023 |
7.0.0.5 | 226 | 3/27/2023 |
7.0.0.4 | 208 | 3/23/2023 |
7.0.0.3 | 271 | 1/31/2023 |
7.0.0.2 | 262 | 1/30/2023 |
7.0.0.1 | 276 | 12/24/2022 |
6.0.2.5 | 318 | 11/16/2022 |
6.0.2.4 | 333 | 11/10/2022 |
6.0.2.3 | 381 | 10/11/2022 |
6.0.2.2 | 452 | 9/23/2022 |
6.0.2.1 | 473 | 8/14/2022 |
6.0.1.9 | 470 | 8/13/2022 |
6.0.1.8 | 482 | 6/6/2022 |
6.0.1.7 | 505 | 5/26/2022 |
6.0.1.6 | 527 | 5/11/2022 |
6.0.1.5 | 488 | 5/10/2022 |
6.0.1.4 | 531 | 4/8/2022 |
6.0.1.3 | 522 | 4/2/2022 |
6.0.1.2 | 534 | 4/2/2022 |
6.0.1.1 | 548 | 3/18/2022 |
6.0.0.9 | 542 | 3/5/2022 |
6.0.0.8 | 551 | 2/19/2022 |
6.0.0.7 | 550 | 2/15/2022 |
6.0.0.6 | 552 | 2/14/2022 |
6.0.0.5 | 584 | 1/28/2022 |
6.0.0.4 | 471 | 1/13/2022 |
6.0.0.3 | 458 | 1/12/2022 |
6.0.0.2 | 299 | 12/21/2021 |
6.0.0.1 | 309 | 12/13/2021 |
5.0.3.7 | 471 | 10/16/2021 |
5.0.3.6 | 402 | 10/14/2021 |
5.0.3.5 | 373 | 10/13/2021 |
5.0.3.4 | 411 | 10/8/2021 |
5.0.3.3 | 389 | 9/17/2021 |
5.0.3.2 | 430 | 9/16/2021 |
5.0.3.1 | 380 | 9/15/2021 |
5.0.2.9 | 427 | 9/15/2021 |
5.0.2.8 | 397 | 8/31/2021 |
5.0.2.7 | 408 | 8/28/2021 |
5.0.2.6 | 386 | 8/22/2021 |
5.0.2.5 | 386 | 8/13/2021 |
5.0.2.4 | 329 | 8/13/2021 |
5.0.2.3 | 440 | 7/8/2021 |
5.0.2.2 | 395 | 7/1/2021 |
5.0.2.1 | 481 | 6/16/2021 |
5.0.1.9 | 384 | 5/12/2021 |
5.0.1.8 | 391 | 5/9/2021 |
5.0.1.7 | 429 | 5/7/2021 |
5.0.1.6 | 424 | 4/17/2021 |
5.0.1.5 | 364 | 4/16/2021 |
5.0.1.4 | 435 | 4/15/2021 |
5.0.1.3 | 372 | 4/15/2021 |
5.0.1.2 | 410 | 4/12/2021 |