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" />
                    
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.9
                    
#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
                    
Install as a Cake Addin
#tool nuget:?package=EaCloud.EntityFrameworkCore.SqlServer&version=9.0.0.9
                    
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.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