EaCloud.EntityFrameworkCore.SqlServer 9.0.0.8

dotnet add package EaCloud.EntityFrameworkCore.SqlServer --version 9.0.0.8
                    
NuGet\Install-Package EaCloud.EntityFrameworkCore.SqlServer -Version 9.0.0.8
                    
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.8" />
                    
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.8" />
                    
Directory.Packages.props
<PackageReference Include="EaCloud.EntityFrameworkCore.SqlServer" />
                    
Project file
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.8
                    
#r "nuget: EaCloud.EntityFrameworkCore.SqlServer, 9.0.0.8"
                    
#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.8
                    
#: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.8
                    
Install as a Cake Addin
#tool nuget:?package=EaCloud.EntityFrameworkCore.SqlServer&version=9.0.0.8
                    
Install as a Cake Tool

EaCloud SqlServer 数据库组件

Member project of EaCloud Team NuGet Badge GitHub license

说明

  1. EaCloud SqlServer 数据库组件,封装基于 Microsoft.EntityFrameworkCore.SqlServer 的数据访问功能的实现。
  2. 支持 SQL Server 2012 以上版本。

用法

可按照如下配置方式使用:

  1. 通过nuget引用 EaCloud.EntityFrameworkCore.SqlServer 程序集
Install-Package EaCloud.EntityFrameworkCore.SqlServer
  1. 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 WeChat
QQ群号:863605868 微信号:SeonHu
Product 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.

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.8 83 7/5/2025
9.0.0.7 161 6/25/2025
9.0.0.6 166 6/18/2025
9.0.0.5 166 6/14/2025
9.0.0.4 186 5/8/2025
9.0.0.3 180 4/23/2025
9.0.0.2 195 4/11/2025
9.0.0.1 169 3/21/2025
8.0.1.9 169 11/15/2024
8.0.1.8 156 11/13/2024
8.0.1.7 170 10/9/2024
8.0.1.6 163 9/29/2024
8.0.1.5 159 9/13/2024
8.0.1.4 191 8/10/2024
8.0.1.3 174 8/7/2024
8.0.1.2 168 8/7/2024
8.0.1.1 174 8/7/2024
8.0.0.9 177 8/7/2024
8.0.0.8 119 8/5/2024
8.0.0.7 129 8/2/2024
8.0.0.6 136 8/1/2024
8.0.0.5 137 8/1/2024
8.0.0.4 120 7/31/2024
8.0.0.3 135 7/30/2024
8.0.0.2 158 7/25/2024
8.0.0.1 137 7/24/2024
7.0.9.4 180 7/19/2024
7.0.9.3 156 7/11/2024
7.0.9.2 158 7/6/2024
7.0.9.1 144 7/3/2024
7.0.8.9 155 6/28/2024
7.0.8.8 158 6/26/2024
7.0.8.7 161 6/22/2024
7.0.8.6 156 6/14/2024
7.0.8.5 175 5/31/2024
7.0.8.4 167 5/21/2024
7.0.8.3 154 5/21/2024
7.0.8.2 146 5/20/2024
7.0.8.1 156 5/20/2024
7.0.7.9 153 5/15/2024
7.0.7.8 158 5/10/2024
7.0.7.7 149 5/9/2024
7.0.7.6 149 5/9/2024
7.0.7.5 164 5/7/2024
7.0.7.4 162 4/28/2024
7.0.7.3 160 4/26/2024
7.0.7.2 164 4/21/2024
7.0.7.1 161 4/19/2024
7.0.6.9 168 4/15/2024
7.0.6.8 142 4/11/2024
7.0.6.7 167 4/11/2024
7.0.6.6 156 4/7/2024
7.0.6.5 154 4/7/2024
7.0.6.4 170 4/7/2024
7.0.6.3 156 4/7/2024
7.0.6.2 166 4/3/2024
7.0.6.1 169 4/3/2024
7.0.5.9 170 3/27/2024
7.0.5.8 153 3/23/2024
7.0.5.7 187 3/17/2024
7.0.5.6 167 3/17/2024
7.0.5.5 163 3/16/2024
7.0.5.4 164 3/13/2024
7.0.5.3 162 3/13/2024
7.0.5.2 183 3/6/2024
7.0.5.1 163 2/21/2024
7.0.4.9 163 2/21/2024
7.0.4.8 169 2/18/2024
7.0.4.7 173 2/5/2024
7.0.4.6 165 2/1/2024
7.0.4.5 161 1/26/2024
7.0.4.4 165 1/22/2024
7.0.4.3 179 1/17/2024
7.0.4.2 176 1/16/2024
7.0.4.1 158 1/16/2024
7.0.3.9 154 1/15/2024
7.0.3.8 191 1/3/2024
7.0.3.7 168 12/28/2023
7.0.3.6 156 12/27/2023
7.0.3.5 188 12/22/2023
7.0.3.4 170 12/22/2023
7.0.3.3 189 12/13/2023
7.0.3.2 155 12/13/2023
7.0.3.1 183 12/12/2023
7.0.2.9 174 11/26/2023
7.0.2.8 155 11/26/2023
7.0.2.7 188 9/26/2023
7.0.2.6 174 9/25/2023
7.0.2.5 186 9/15/2023
7.0.2.4 182 7/27/2023
7.0.2.3 210 7/22/2023
7.0.2.2 216 7/22/2023
7.0.2.1 226 7/21/2023
7.0.1.9 213 7/21/2023
7.0.1.8 204 7/20/2023
7.0.1.7 208 7/20/2023
7.0.1.6 226 7/4/2023
7.0.1.5 197 6/16/2023
7.0.1.4 193 6/13/2023
7.0.1.3 189 6/8/2023
7.0.1.2 185 6/2/2023
7.0.1.1 208 5/11/2023
7.0.0.9 189 5/10/2023
7.0.0.8 194 5/10/2023
7.0.0.7 261 4/19/2023
7.0.0.6 221 4/18/2023
7.0.0.5 277 3/27/2023
7.0.0.4 257 3/23/2023
7.0.0.3 325 1/31/2023
7.0.0.2 312 1/30/2023
7.0.0.1 327 12/24/2022
6.0.2.5 369 11/16/2022
6.0.2.4 393 11/10/2022
6.0.2.3 438 10/11/2022
6.0.2.2 511 9/23/2022
6.0.2.1 530 8/14/2022
6.0.1.9 531 8/13/2022
6.0.1.8 542 6/6/2022
6.0.1.7 569 5/26/2022
6.0.1.6 595 5/11/2022
6.0.1.5 554 5/10/2022
6.0.1.4 595 4/8/2022
6.0.1.3 590 4/2/2022
6.0.1.2 602 4/2/2022
6.0.1.1 614 3/18/2022
6.0.0.9 608 3/5/2022
6.0.0.8 619 2/19/2022
6.0.0.7 623 2/15/2022
6.0.0.6 624 2/14/2022
6.0.0.5 656 1/28/2022
6.0.0.4 540 1/13/2022
6.0.0.3 530 1/12/2022
6.0.0.2 374 12/21/2021
6.0.0.1 381 12/13/2021
5.0.3.7 545 10/16/2021
5.0.3.6 475 10/14/2021
5.0.3.5 447 10/13/2021
5.0.3.4 481 10/8/2021
5.0.3.3 461 9/17/2021
5.0.3.2 500 9/16/2021
5.0.3.1 452 9/15/2021
5.0.2.9 504 9/15/2021
5.0.2.8 467 8/31/2021
5.0.2.7 481 8/28/2021
5.0.2.6 461 8/22/2021
5.0.2.5 455 8/13/2021
5.0.2.4 400 8/13/2021
5.0.2.3 510 7/8/2021
5.0.2.2 470 7/1/2021
5.0.2.1 552 6/16/2021
5.0.1.9 458 5/12/2021
5.0.1.8 466 5/9/2021
5.0.1.7 503 5/7/2021
5.0.1.6 506 4/17/2021
5.0.1.5 441 4/16/2021
5.0.1.4 510 4/15/2021
5.0.1.3 446 4/15/2021
5.0.1.2 489 4/12/2021