OrangeCloud.Core 3.2.7.1

There is a newer version of this package available.
See the version list below for details.
dotnet add package OrangeCloud.Core --version 3.2.7.1
                    
NuGet\Install-Package OrangeCloud.Core -Version 3.2.7.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="OrangeCloud.Core" Version="3.2.7.1" />
                    
For projects that support PackageReference, copy this XML node into the project file to reference the package.
<PackageVersion Include="OrangeCloud.Core" Version="3.2.7.1" />
                    
Directory.Packages.props
<PackageReference Include="OrangeCloud.Core" />
                    
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 OrangeCloud.Core --version 3.2.7.1
                    
#r "nuget: OrangeCloud.Core, 3.2.7.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.
#addin nuget:?package=OrangeCloud.Core&version=3.2.7.1
                    
Install as a Cake Addin
#tool nuget:?package=OrangeCloud.Core&version=3.2.7.1
                    
Install as a Cake Tool

OrangeCloud.Core

OrangeCloud.Core 是一个基于 dapper 的 ORM

功能介绍

  1. 支持批量生成数据表实体类
运行:go.aspx
  1. 支持分表插入
ORM.Build<T>()
.Insert(model, true)
.SetSplitTable(new MSplitTableConfig { Type = ESplitTableType.DateTime, DateTimeConfig = "yyyyMM" })
.Execute();
  1. 支持读写分离
// 读库:
<add key="FSystemRead" value="server=192.168.1.101,192.168.1.102,192.168.1.103;database=FSystem;uid=sa;pwd=123456"/>

// 写库:
<add key="FSystemWrite" value="server=192.168.1.100;database=FSystem;uid=sa;pwd=123456"/>
  1. 支持 BulkCopy
// 数据类型:DataTable
ORM.Build<T>().BulkCopy(dataTable);

// 数据类型:List<T>
// 参数 2:指定插入的列
ORM.Build<T>().BulkCopy(listData, o => new { o.col1, o.col2 });
  1. 支持动态查询写法(根据参数自动拼接条件)
// 可访问菜单:按条件查询
https://www.107000.com/T-Doc/7
  1. 支持简便的分页查询
ORM.Build<T>()
.Get(it => it.Where(o => o.Mark > 0).OrderBy(o => o.CreateDate))
.ToPageList(1, 30);
  1. 支持简便的事务处理
using(var trans = ORM.TransMaster())
{
    --插入数据并获得ID
    var id = ORM.Insert(model, true);
    --修改数据
    ORM.Update(model);
    --提交事务
    trans.Complete();
}

如何使用

  1. 单独创建 Entity 层,在 Entity 层引用 OrangeCloud.Core.dll
  2. 配置项目 config 文件
{

  "ConfigType": "Production",

  "OrangeCloud.Core.DataTable.Type": "SqlServer", //数据库类型:(SqlServer;MySql;)

  "OrangeCloud.Core.DatabaseKey.Prefix": "", //数据库Key前缀

  "OrangeCloud.Core.DatabaseKey.Suffix": "", //数据库Key后缀

  "OrangeCloud.Core.DatabaseConfig.Encryption": false, //数据库Config.Value是否加密 true,false

  "OrangeCloud.Core.FillEntity": "OrangeCloud.CoreEntity,OrangeCloud.CoreEntity,FillEntity", //填充系统字段映射的实现类

  "OrangeCloud.Core.IsDebug": false, //是否是调试(true=调试模式:忽略菜单权限, false=正式环境)

  "OrangeCloud.Log.IsSave": false, //是否输出SQL语句

  "OrangeCloud.Log.SavePath": "E:\\Log\\", //输出路径

  "OrangeCloud.Cookie.Login": "OrangeCloudOMS", //单点登录Cookie Name

  "OrangeCloud.Cache.ServerList": "127.0.0.1:10600", //分布式缓存服务器:OCache

  "OrangeCloud.Redis.ServerList": "127.0.0.1:6379", //分布式缓存服务器:Redis

  "OrangeCloud.Upload.ServerList": "127.0.0.1:10300", //分布式上传服务器

  "OrangeCloud.Upload.FileUrl": "https://cdn.xxx.com/", //分布式文件查看地址

  // 写库
  "DBWrite": "server=127.0.0.1\\SQL2016,1433;database=DB;uid=sa;pwd=123456;",

  // 读库
  "DBRead": "server=127.0.0.1\\SQL2016,1433;database=DB;uid=sa;pwd=123456;"

}

作者

樊嵘

教程

https://www.107000.com/T-Doc/1

更新日志

https://www.107000.com/T-Doc/2085

Product Compatible and additional computed target framework versions.
.NET net5.0 was computed.  net5.0-windows was computed.  net6.0 was computed.  net6.0-android was computed.  net6.0-ios was computed.  net6.0-maccatalyst was computed.  net6.0-macos was computed.  net6.0-tvos was computed.  net6.0-windows was computed.  net7.0 was computed.  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.  net9.0 was computed.  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. 
.NET Core netcoreapp3.1 is compatible. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

NuGet packages

This package is not used by any NuGet packages.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last Updated
3.3.1 129 6/25/2025
3.3.0.9 126 6/25/2025
3.3.0.8 217 6/13/2025
3.3.0.6 191 4/16/2025
3.3.0.5 192 4/16/2025
3.3.0.3 158 4/8/2025
3.3.0.2 157 4/8/2025
3.3.0.1 185 3/9/2025
3.3.0 177 3/9/2025
3.2.9.6 128 1/20/2025
3.2.9.5 133 11/16/2024
3.2.9.3 129 9/24/2024
3.2.9.2 101 9/24/2024
3.2.9.1 108 9/24/2024
3.2.9 104 9/24/2024
3.2.8.9 102 9/24/2024
3.2.8.8 109 9/23/2024
3.2.8.7 99 9/23/2024
3.2.8.6 136 9/17/2024
3.2.8.5 88 8/3/2024
3.2.8.3 91 8/3/2024
3.2.8.2 80 7/29/2024
3.2.8.1 123 7/12/2024
3.2.8 115 7/4/2024
3.2.7.9 108 6/25/2024
3.2.7.8 97 6/25/2024
3.2.7.7 113 6/3/2024
3.2.7.6 94 6/2/2024
3.2.7.5 135 5/7/2024
3.2.7.3 129 4/29/2024
3.2.7.2 122 4/29/2024
3.2.7.1 119 3/25/2024
3.2.7 118 3/23/2024
3.2.6.9 152 1/30/2024
3.2.6.8 144 1/10/2024
3.2.6.7 188 12/7/2023
3.2.6.6 127 12/7/2023
3.2.6.5 162 12/3/2023
3.2.6.3 148 11/13/2023
3.2.6.2 124 11/8/2023
3.2.6.1 141 11/6/2023
3.2.6 147 11/5/2023
3.2.5.2 155 10/21/2023
3.2.5.1 210 8/16/2023
3.2.3.9 253 3/14/2023
3.2.3.8 398 11/22/2022
3.2.3.6 368 11/22/2022
3.2.3.5 357 11/22/2022
3.2.3.3 392 11/15/2022
3.2.3.2 418 11/9/2022
3.2.3.1 404 11/9/2022
3.2.3 396 11/9/2022
3.2.2.9 397 11/8/2022
3.2.2.8 399 11/8/2022
3.2.2.6 388 11/7/2022
3.2.2.5 419 11/3/2022
3.2.2.3 435 11/3/2022
3.2.2.2 409 11/3/2022
3.2.2.1 430 11/3/2022
3.2.2 409 11/3/2022
3.2.1.9 401 11/3/2022
3.2.1.8 402 11/3/2022
3.2.1.6 436 11/1/2022
3.2.1.5 452 10/28/2022
3.2.1.3 450 10/27/2022
3.2.1.2 463 10/27/2022
3.2.1.1 429 10/26/2022
3.2.1 456 10/26/2022
3.2.0.9 444 10/26/2022
3.2.0.8 461 10/24/2022
3.2.0.7 447 10/24/2022
3.2.0.6 472 10/24/2022
3.2.0.5 470 10/24/2022
3.2.0.3 481 10/21/2022
3.2.0.2 475 10/12/2022
3.2.0.1 480 10/11/2022
3.2.0 487 10/8/2022
3.1.1.1 526 9/21/2022
3.1.1 618 6/21/2022
3.1.0.8 764 1/21/2022
3.1.0.7 729 1/21/2022
3.1.0.6 752 1/18/2022
3.1.0.5 592 1/12/2022
3.1.0.3 786 7/28/2020
3.1.0.2 691 7/28/2020
3.1.0.1 789 2/26/2020
2.2.1.6 736 10/18/2019
2.2.1.5 656 10/18/2019
2.2.1.3 669 10/17/2019
2.2.1.2 807 12/26/2018
2.2.1.1 851 12/18/2018
2.2.1 1,236 4/18/2018
2.2.0.9 1,217 4/18/2018
2.2.0.8 1,279 2/7/2017
2.2.0.6 1,156 2/7/2017
2.2.0.3 1,189 12/22/2016
2.2.0.2 1,181 12/22/2016
2.2.0.1 1,262 11/23/2016
2.2.0 1,211 11/22/2016
2.1.0 1,181 11/14/2016
2.0.8.3 1,299 11/13/2016
2.0.8.2 1,201 9/28/2016
2.0.8.1 1,173 9/8/2016
2.0.7.10 1,174 9/7/2016
2.0.7.9 1,255 9/7/2016
2.0.7.8 1,154 9/7/2016
2.0.7.7 1,147 9/7/2016
2.0.7.6 1,159 9/2/2016
2.0.7.5 1,188 9/1/2016
2.0.7.3 1,185 8/31/2016
2.0.7.2 1,195 8/29/2016
2.0.7.1 1,181 8/29/2016
2.0.6.36 1,157 8/27/2016
2.0.6.32 1,158 8/27/2016
2.0.6.28 1,224 8/27/2016
2.0.6.26 1,209 8/27/2016
2.0.6.22 1,207 8/18/2016
2.0.6.20 1,153 8/18/2016
2.0.6.16 1,189 8/18/2016
2.0.6.13 1,173 8/18/2016
2.0.6.11 1,172 8/17/2016
2.0.6.9 1,190 7/7/2016
2.0.6.6 1,464 6/15/2016
2.0.6.5 1,173 6/7/2016
2.0.6.3 1,425 6/7/2016
2.0.6.2 1,178 6/7/2016
2.0.6 1,211 4/10/2016