EaCloud.EntityFrameworkCore.SqlServer 7.0.2.7

There is a newer version of this package available.
See the version list below for details.
dotnet add package EaCloud.EntityFrameworkCore.SqlServer --version 7.0.2.7                
NuGet\Install-Package EaCloud.EntityFrameworkCore.SqlServer -Version 7.0.2.7                
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.2.7" />                
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.2.7                
#r "nuget: EaCloud.EntityFrameworkCore.SqlServer, 7.0.2.7"                
#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.2.7

// Install EaCloud.EntityFrameworkCore.SqlServer as a Cake Tool
#tool nuget:?package=EaCloud.EntityFrameworkCore.SqlServer&version=7.0.2.7                

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=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, //是否允许审计实体
        "MigrationAssemblyName": "EaCloud.Svc.Web", //迁移的程序集名称(为空时默认"DesignTimeXXXDbContextFactory"所在程序集)
        "MigrationEnabled": true //启用自动迁移
      }
    },
}

交流

QQ WeChat
QQ群号:863605868 微信号:SeonHu
Product 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.

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