OrangeCloud.Core 3.2.8.7

There is a newer version of this package available.
See the version list below for details.

dotnet add package OrangeCloud.Core --version 3.2.8.7

NuGet\Install-Package OrangeCloud.Core -Version 3.2.8.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="OrangeCloud.Core" Version="3.2.8.7" />

For projects that support PackageReference, copy this XML node into the project file to reference the package.

paket add OrangeCloud.Core --version 3.2.8.7

The NuGet Team does not provide support for this client. Please contact its maintainers for support.

#r "nuget: OrangeCloud.Core, 3.2.8.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 OrangeCloud.Core as a Cake Addin
#addin nuget:?package=OrangeCloud.Core&version=3.2.8.7

// Install OrangeCloud.Core as a Cake Tool
#tool nuget:?package=OrangeCloud.Core&version=3.2.8.7

The NuGet Team does not provide support for this client. Please contact its maintainers for support.

OrangeCloud.Core

OrangeCloud.Core 是一个基于 dapper 的 ORM

功能介绍

支持批量生成数据表实体类

运行：go.aspx

支持分表插入

ORM.Build<T>()
.Insert(model, true)
.SetSplitTable(new MSplitTableConfig { Type = ESplitTableType.DateTime, DateTimeConfig = "yyyyMM" })
.Execute();

支持读写分离

// 读库:
<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"/>

支持 BulkCopy

// 数据类型：DataTable
ORM.Build<T>().BulkCopy(dataTable);

// 数据类型：List<T>
// 参数 2：指定插入的列
ORM.Build<T>().BulkCopy(listData, o => new { o.col1, o.col2 });

支持动态查询写法（根据参数自动拼接条件）

// 可访问菜单：按条件查询
https://www.107000.com/T-Doc/7

支持简便的分页查询

ORM.Build<T>()
.Get(it => it.Where(o => o.Mark > 0).OrderBy(o => o.CreateDate))
.ToPageList(1, 30);

支持简便的事务处理

using(var trans = ORM.TransMaster())
{
    --插入数据并获得ID
    var id = ORM.Insert(model, true);
    --修改数据
    ORM.Update(model);
    --提交事务
    trans.Complete();
}

如何使用

单独创建 Entity 层，在 Entity 层引用 OrangeCloud.Core.dll
配置项目 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.
.NET Core	netcoreapp3.1 is compatible.

Product

.NET

.NET Core

Compatible target framework(s)

Included target framework(s) (in package)

Learn more about Target Frameworks and .NET Standard.

.NETCoreApp 3.1
- AutoMapper (>= 9.0.0)
- Consul (>= 1.7.14.3)
- Dapper (>= 2.1.35)
- Dapr.AspNetCore (>= 1.9.0)
- Microsoft.AspNetCore.Hosting.Abstractions (>= 2.2.0)
- Microsoft.AspNetCore.Http.Abstractions (>= 2.2.0)
- Microsoft.AspNetCore.Mvc (>= 2.2.0)
- Microsoft.Extensions.Configuration (>= 8.0.0)
- Microsoft.Extensions.Configuration.Abstractions (>= 8.0.0)
- Microsoft.Extensions.Configuration.Json (>= 8.0.0)
- Microsoft.Extensions.DependencyInjection.Abstractions (>= 8.0.1)
- Microsoft.Extensions.Options.ConfigurationExtensions (>= 8.0.0)
- Newtonsoft.Json (>= 13.0.2)
- Oracle.ManagedDataAccess.Core (>= 3.21.140)
- System.Data.SqlClient (>= 4.8.6)

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.2.9.6	95	1/20/2025
3.2.9.5	122	11/16/2024
3.2.9.3	118	9/24/2024
3.2.9.2	91	9/24/2024
3.2.9.1	95	9/24/2024
3.2.9	94	9/24/2024
3.2.8.9	93	9/24/2024
3.2.8.8	100	9/23/2024
3.2.8.7	89	9/23/2024
3.2.8.6	127	9/17/2024
3.2.8.5	72	8/3/2024
3.2.8.3	80	8/3/2024
3.2.8.2	73	7/29/2024
3.2.8.1	112	7/12/2024
3.2.8	107	7/4/2024
3.2.7.9	98	6/25/2024
3.2.7.8	88	6/25/2024
3.2.7.7	103	6/3/2024
3.2.7.6	88	6/2/2024
3.2.7.5	127	5/7/2024
3.2.7.3	122	4/29/2024
3.2.7.2	116	4/29/2024
3.2.7.1	109	3/25/2024
3.2.7	110	3/23/2024
3.2.6.9	143	1/30/2024
3.2.6.8	135	1/10/2024
3.2.6.7	179	12/7/2023
3.2.6.6	120	12/7/2023
3.2.6.5	154	12/3/2023
3.2.6.3	140	11/13/2023
3.2.6.2	114	11/8/2023
3.2.6.1	132	11/6/2023
3.2.6	138	11/5/2023
3.2.5.2	138	10/21/2023
3.2.5.1	185	8/16/2023
3.2.3.9	220	3/14/2023
3.2.3.8	364	11/22/2022
3.2.3.6	336	11/22/2022
3.2.3.5	328	11/22/2022
3.2.3.3	358	11/15/2022
3.2.3.2	383	11/9/2022
3.2.3.1	369	11/9/2022
3.2.3	363	11/9/2022
3.2.2.9	365	11/8/2022
3.2.2.8	370	11/8/2022
3.2.2.6	358	11/7/2022
3.2.2.5	388	11/3/2022
3.2.2.3	405	11/3/2022
3.2.2.2	379	11/3/2022
3.2.2.1	401	11/3/2022
3.2.2	380	11/3/2022
3.2.1.9	371	11/3/2022
3.2.1.8	370	11/3/2022
3.2.1.6	406	11/1/2022
3.2.1.5	417	10/28/2022
3.2.1.3	418	10/27/2022
3.2.1.2	429	10/27/2022
3.2.1.1	399	10/26/2022
3.2.1	420	10/26/2022
3.2.0.9	413	10/26/2022
3.2.0.8	427	10/24/2022
3.2.0.7	412	10/24/2022
3.2.0.6	440	10/24/2022
3.2.0.5	435	10/24/2022
3.2.0.3	450	10/21/2022
3.2.0.2	444	10/12/2022
3.2.0.1	447	10/11/2022
3.2.0	456	10/8/2022
3.1.1.1	492	9/21/2022
3.1.1	577	6/21/2022
3.1.0.8	718	1/21/2022
3.1.0.7	683	1/21/2022
3.1.0.6	706	1/18/2022
3.1.0.5	546	1/12/2022
3.1.0.3	715	7/28/2020
3.1.0.2	624	7/28/2020
3.1.0.1	724	2/26/2020
2.2.1.6	666	10/18/2019
2.2.1.5	589	10/18/2019
2.2.1.3	600	10/17/2019
2.2.1.2	735	12/26/2018
2.2.1.1	772	12/18/2018
2.2.1	1,002	4/18/2018
2.2.0.9	982	4/18/2018
2.2.0.8	1,118	2/7/2017
2.2.0.6	999	2/7/2017
2.2.0.3	1,029	12/22/2016
2.2.0.2	1,022	12/22/2016
2.2.0.1	1,104	11/23/2016
2.2.0	1,050	11/22/2016
2.1.0	1,023	11/14/2016
2.0.8.3	1,139	11/13/2016
2.0.8.2	1,039	9/28/2016
2.0.8.1	1,014	9/8/2016
2.0.7.10	1,012	9/7/2016
2.0.7.9	1,095	9/7/2016
2.0.7.8	996	9/7/2016
2.0.7.7	987	9/7/2016
2.0.7.6	995	9/2/2016
2.0.7.5	1,024	9/1/2016
2.0.7.3	1,024	8/31/2016
2.0.7.2	1,034	8/29/2016
2.0.7.1	1,021	8/29/2016
2.0.6.36	996	8/27/2016
2.0.6.32	999	8/27/2016
2.0.6.28	1,065	8/27/2016
2.0.6.26	1,049	8/27/2016
2.0.6.22	1,048	8/18/2016
2.0.6.20	994	8/18/2016
2.0.6.16	1,027	8/18/2016
2.0.6.13	1,002	8/18/2016
2.0.6.11	1,011	8/17/2016
2.0.6.9	1,032	7/7/2016
2.0.6.6	1,299	6/15/2016
2.0.6.5	1,008	6/7/2016
2.0.6.3	1,265	6/7/2016
2.0.6.2	1,014	6/7/2016
2.0.6	1,049	4/10/2016