OrangeCloud.Core 3.2.7.1

.NET Core 3.1 
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. 
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. 
// Install OrangeCloud.Core as a Cake Addin
#addin nuget:?package=OrangeCloud.Core&version=3.2.7.1

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

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. 
.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.2.7.1 83 3/25/2024
3.2.7 75 3/23/2024
3.2.6.9 100 1/30/2024
3.2.6.8 102 1/10/2024
3.2.6.7 140 12/7/2023
3.2.6.6 80 12/7/2023
3.2.6.5 111 12/3/2023
3.2.6.3 99 11/13/2023
3.2.6.2 78 11/8/2023
3.2.6.1 95 11/6/2023
3.2.6 104 11/5/2023
3.2.5.2 114 10/21/2023
3.2.5.1 147 8/16/2023
3.2.3.9 200 3/14/2023
3.2.3.8 323 11/22/2022
3.2.3.6 313 11/22/2022
3.2.3.5 290 11/22/2022
3.2.3.3 323 11/15/2022
3.2.3.2 347 11/9/2022
3.2.3.1 331 11/9/2022
3.2.3 328 11/9/2022
3.2.2.9 333 11/8/2022
3.2.2.8 334 11/8/2022
3.2.2.6 334 11/7/2022
3.2.2.5 367 11/3/2022
3.2.2.3 369 11/3/2022
3.2.2.2 357 11/3/2022
3.2.2.1 364 11/3/2022
3.2.2 347 11/3/2022
3.2.1.9 350 11/3/2022
3.2.1.8 336 11/3/2022
3.2.1.6 358 11/1/2022
3.2.1.5 381 10/28/2022
3.2.1.3 376 10/27/2022
3.2.1.2 386 10/27/2022
3.2.1.1 361 10/26/2022
3.2.1 397 10/26/2022
3.2.0.9 389 10/26/2022
3.2.0.8 371 10/24/2022
3.2.0.7 373 10/24/2022
3.2.0.6 403 10/24/2022
3.2.0.5 412 10/24/2022
3.2.0.3 412 10/21/2022
3.2.0.2 402 10/12/2022
3.2.0.1 413 10/11/2022
3.2.0 423 10/8/2022
3.1.1.1 455 9/21/2022
3.1.1 539 6/21/2022
3.1.0.8 675 1/21/2022
3.1.0.7 647 1/21/2022
3.1.0.6 674 1/18/2022
3.1.0.5 512 1/12/2022
3.1.0.3 642 7/28/2020
3.1.0.2 602 7/28/2020
3.1.0.1 688 2/26/2020
2.2.1.6 611 10/18/2019
2.2.1.5 556 10/18/2019
2.2.1.3 564 10/17/2019
2.2.1.2 694 12/26/2018
2.2.1.1 718 12/18/2018
2.2.1 955 4/18/2018
2.2.0.9 934 4/18/2018
2.2.0.8 1,071 2/7/2017
2.2.0.6 951 2/7/2017
2.2.0.3 982 12/22/2016
2.2.0.2 977 12/22/2016
2.2.0.1 1,058 11/23/2016
2.2.0 1,004 11/22/2016
2.1.0 978 11/14/2016
2.0.8.3 1,087 11/13/2016
2.0.8.2 990 9/28/2016
2.0.8.1 967 9/8/2016
2.0.7.10 967 9/7/2016
2.0.7.9 1,050 9/7/2016
2.0.7.8 953 9/7/2016
2.0.7.7 943 9/7/2016
2.0.7.6 947 9/2/2016
2.0.7.5 979 9/1/2016
2.0.7.3 975 8/31/2016
2.0.7.2 984 8/29/2016
2.0.7.1 976 8/29/2016
2.0.6.36 949 8/27/2016
2.0.6.32 954 8/27/2016
2.0.6.28 1,016 8/27/2016
2.0.6.26 1,003 8/27/2016
2.0.6.22 996 8/18/2016
2.0.6.20 949 8/18/2016
2.0.6.16 984 8/18/2016
2.0.6.13 956 8/18/2016
2.0.6.11 968 8/17/2016
2.0.6.9 982 7/7/2016
2.0.6.6 1,251 6/15/2016
2.0.6.5 964 6/7/2016
2.0.6.3 1,218 6/7/2016
2.0.6.2 967 6/7/2016
2.0.6 1,005 4/10/2016