EaCloud.EntityFrameworkCore.Sqlite 9.0.0.8

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

EaCloud Sqlite 数据库组件

Member project of EaCloud Team NuGet Badge GitHub license

说明

  1. EaCloud Sqlite 数据库组件,封装基于 Microsoft.EntityFrameworkCore.Sqlite 的数据访问功能的实现。
  2. 支持 SQLite 3.7 及以上版本。

用法

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

  1. 通过nuget引用 EaCloud.EntityFrameworkCore.Sqlite 程序集
Install-Package EaCloud.EntityFrameworkCore.Sqlite
  1. appsettings.json 中的 EaCloud 节点下添加如下配置节点
{
    //数据库上下文集合
    "DbContexts": {
      //默认数据库上下文
      "DefaultDbContext": {
        "DbContextTypeName": "EaCloud.Entity.DefaultDbContext,EaCloud.EntityFrameworkCore", //上下文类型全名(默认数据库上下文)
        "DatabaseType": "Sqlite", //数据库类型:"Cosmos"(Azure Cosmos DB 的 SQL API)、"Kdbndp"(人大金仓)、"MySql"、"Oracle"、"PostgreSql"、"Sqlite"、"SqlServer"
        "ConnectionString": "data source=EaCloud_DEV.db", //连接字符串(Sqlite)
        //从数据库配置
        "SlaveDatabase": {
          "SlaveSelector": "Weight", //从数据库选择策略:Weight(平滑权重)、Random(随机)、Sequence(顺序轮询)
          //从数据库集合
          "SlaveDatabases": [
            {
              "Name": "Slave01", //数据库名
              "Weight": 2, //权重(1-100)
              "ConnectionString": "data source=EaCloud_DEV.Slave01.db", //连接字符串(Sqlite)
            },
            {
              "Name": "Slave02", //数据库名
              "Weight": 5, //权重(1-100)
              "ConnectionString": "data source=EaCloud_DEV.Slave02.db", //连接字符串(Sqlite)
            }
          ]
        },
        "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.Sqlite:

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 71 7/5/2025
9.0.0.7 167 6/25/2025
9.0.0.6 167 6/18/2025
9.0.0.5 169 6/14/2025
9.0.0.4 179 5/8/2025
9.0.0.3 204 4/23/2025
9.0.0.2 198 4/11/2025
9.0.0.1 171 3/21/2025
8.0.1.9 186 11/15/2024
8.0.1.8 161 11/13/2024
8.0.1.7 172 10/9/2024
8.0.1.6 165 9/29/2024
8.0.1.5 166 9/13/2024
8.0.1.4 202 8/10/2024
8.0.1.3 167 8/7/2024
8.0.1.2 171 8/7/2024
8.0.1.1 161 8/7/2024
8.0.0.9 162 8/7/2024
8.0.0.8 134 8/5/2024
8.0.0.7 137 8/2/2024
8.0.0.6 150 8/1/2024
8.0.0.5 147 8/1/2024
8.0.0.4 117 7/31/2024
8.0.0.3 136 7/30/2024
8.0.0.2 155 7/25/2024
8.0.0.1 147 7/24/2024
7.0.9.4 174 7/19/2024
7.0.9.3 155 7/11/2024
7.0.9.2 157 7/6/2024
7.0.9.1 156 7/3/2024
7.0.8.9 169 6/28/2024
7.0.8.8 156 6/26/2024
7.0.8.7 160 6/22/2024
7.0.8.6 170 6/14/2024
7.0.8.5 169 5/31/2024
7.0.8.4 162 5/21/2024
7.0.8.3 165 5/21/2024
7.0.8.2 155 5/20/2024
7.0.8.1 157 5/20/2024
7.0.7.9 167 5/15/2024
7.0.7.8 140 5/10/2024
7.0.7.7 145 5/9/2024
7.0.7.6 155 5/9/2024
7.0.7.5 179 5/7/2024
7.0.7.4 171 4/28/2024
7.0.7.3 162 4/26/2024
7.0.7.2 169 4/21/2024
7.0.7.1 174 4/19/2024
7.0.6.9 169 4/15/2024
7.0.6.8 152 4/11/2024
7.0.6.7 142 4/11/2024
7.0.6.6 165 4/7/2024
7.0.6.5 168 4/7/2024
7.0.6.4 169 4/7/2024
7.0.6.3 162 4/7/2024
7.0.6.2 166 4/3/2024
7.0.6.1 174 4/3/2024
7.0.5.9 172 3/27/2024
7.0.5.8 151 3/23/2024
7.0.5.7 163 3/17/2024
7.0.5.6 169 3/17/2024
7.0.5.5 165 3/16/2024
7.0.5.4 173 3/13/2024
7.0.5.3 179 3/13/2024
7.0.5.2 172 3/6/2024
7.0.5.1 177 2/21/2024
7.0.4.9 165 2/21/2024
7.0.4.8 177 2/18/2024
7.0.4.7 173 2/5/2024
7.0.4.6 164 2/1/2024
7.0.4.5 177 1/26/2024
7.0.4.4 166 1/22/2024
7.0.4.3 174 1/17/2024
7.0.4.2 176 1/16/2024
7.0.4.1 154 1/16/2024
7.0.3.9 158 1/15/2024
7.0.3.8 216 1/3/2024
7.0.3.7 185 12/28/2023
7.0.3.6 182 12/27/2023
7.0.3.5 174 12/22/2023
7.0.3.4 159 12/22/2023
7.0.3.3 190 12/13/2023
7.0.3.2 154 12/13/2023
7.0.3.1 164 12/12/2023
7.0.2.9 182 11/26/2023
7.0.2.8 152 11/26/2023
7.0.2.7 190 9/26/2023
7.0.2.6 176 9/25/2023
7.0.2.5 169 9/15/2023
7.0.2.4 201 7/27/2023
7.0.2.3 227 7/22/2023
7.0.2.2 211 7/22/2023
7.0.2.1 210 7/21/2023
7.0.1.9 203 7/21/2023
7.0.1.8 193 7/20/2023
7.0.1.7 220 7/20/2023
7.0.1.6 204 7/4/2023
7.0.1.5 188 6/16/2023
7.0.1.4 185 6/13/2023
7.0.1.3 201 6/8/2023
7.0.1.2 190 6/2/2023
7.0.1.1 221 5/11/2023
7.0.0.9 204 5/10/2023
7.0.0.8 194 5/10/2023
7.0.0.7 223 4/19/2023
7.0.0.6 216 4/18/2023
7.0.0.5 271 3/27/2023
7.0.0.4 273 3/23/2023
7.0.0.3 343 1/31/2023
7.0.0.2 339 1/30/2023
7.0.0.1 370 12/24/2022
6.0.2.5 388 11/16/2022
6.0.2.4 395 11/10/2022
6.0.2.3 611 10/11/2022
6.0.2.2 511 9/23/2022
6.0.2.1 522 8/14/2022
6.0.1.9 504 8/13/2022
6.0.1.8 1,322 6/6/2022
6.0.1.7 571 5/26/2022
6.0.1.6 594 5/11/2022
6.0.1.5 564 5/10/2022
6.0.1.4 626 4/8/2022
6.0.1.3 641 4/2/2022
6.0.1.2 581 4/2/2022
6.0.1.1 829 3/18/2022
6.0.0.9 643 3/5/2022
6.0.0.8 670 2/19/2022
6.0.0.7 626 2/15/2022
6.0.0.6 628 2/14/2022
6.0.0.5 639 1/28/2022
6.0.0.4 543 1/13/2022
6.0.0.3 544 1/12/2022
6.0.0.2 410 12/21/2021
6.0.0.1 415 12/13/2021
5.0.3.7 511 10/16/2021
5.0.3.6 440 10/14/2021
5.0.3.5 473 10/13/2021
5.0.3.4 494 10/8/2021
5.0.3.3 444 9/17/2021
5.0.3.2 488 9/16/2021
5.0.3.1 442 9/15/2021
5.0.2.9 423 9/15/2021
5.0.2.8 452 8/31/2021
5.0.2.7 508 8/28/2021
5.0.2.6 493 8/22/2021
5.0.2.5 437 8/13/2021
5.0.2.4 442 8/13/2021
5.0.2.3 541 7/8/2021
5.0.2.2 476 7/1/2021
5.0.2.1 518 6/16/2021
5.0.1.9 410 5/12/2021
5.0.1.8 449 5/9/2021
5.0.1.7 489 5/7/2021
5.0.1.6 516 4/17/2021
5.0.1.5 478 4/16/2021
5.0.1.4 440 4/15/2021
5.0.1.3 456 4/15/2021
5.0.1.2 465 4/12/2021