OrangeCloud.Core
3.2.6.5
There is a newer version of this package available.
See the version list below for details.
See the version list below for details.
dotnet add package OrangeCloud.Core --version 3.2.6.5
NuGet\Install-Package OrangeCloud.Core -Version 3.2.6.5
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.6.5" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add OrangeCloud.Core --version 3.2.6.5
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: OrangeCloud.Core, 3.2.6.5"
#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.6.5
// Install OrangeCloud.Core as a Cake Tool
#tool nuget:?package=OrangeCloud.Core&version=3.2.6.5
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
更新日志
Product | Versions 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.
-
.NETCoreApp 3.1
- AutoMapper (>= 9.0.0)
- Consul (>= 0.7.2.6)
- Dapper (>= 2.0.30)
- 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 (>= 2.2.0)
- Microsoft.Extensions.Configuration.Abstractions (>= 2.2.0)
- Microsoft.Extensions.Configuration.Json (>= 2.2.0)
- Microsoft.Extensions.DependencyInjection.Abstractions (>= 2.2.0)
- Microsoft.Extensions.Options.ConfigurationExtensions (>= 2.2.0)
- Newtonsoft.Json (>= 13.0.1)
- System.Data.SqlClient (>= 4.8.0)
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.5 | 77 | 5/7/2024 |
3.2.7.3 | 83 | 4/29/2024 |
3.2.7.2 | 80 | 4/29/2024 |
3.2.7.1 | 86 | 3/25/2024 |
3.2.7 | 78 | 3/23/2024 |
3.2.6.9 | 102 | 1/30/2024 |
3.2.6.8 | 104 | 1/10/2024 |
3.2.6.7 | 142 | 12/7/2023 |
3.2.6.6 | 82 | 12/7/2023 |
3.2.6.5 | 113 | 12/3/2023 |
3.2.6.3 | 101 | 11/13/2023 |
3.2.6.2 | 80 | 11/8/2023 |
3.2.6.1 | 97 | 11/6/2023 |
3.2.6 | 106 | 11/5/2023 |
3.2.5.2 | 116 | 10/21/2023 |
3.2.5.1 | 149 | 8/16/2023 |
3.2.3.9 | 202 | 3/14/2023 |
3.2.3.8 | 325 | 11/22/2022 |
3.2.3.6 | 315 | 11/22/2022 |
3.2.3.5 | 292 | 11/22/2022 |
3.2.3.3 | 323 | 11/15/2022 |
3.2.3.2 | 349 | 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 | 696 | 12/26/2018 |
2.2.1.1 | 720 | 12/18/2018 |
2.2.1 | 957 | 4/18/2018 |
2.2.0.9 | 937 | 4/18/2018 |
2.2.0.8 | 1,073 | 2/7/2017 |
2.2.0.6 | 953 | 2/7/2017 |
2.2.0.3 | 984 | 12/22/2016 |
2.2.0.2 | 979 | 12/22/2016 |
2.2.0.1 | 1,060 | 11/23/2016 |
2.2.0 | 1,006 | 11/22/2016 |
2.1.0 | 980 | 11/14/2016 |
2.0.8.3 | 1,089 | 11/13/2016 |
2.0.8.2 | 992 | 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 | 949 | 9/2/2016 |
2.0.7.5 | 980 | 9/1/2016 |
2.0.7.3 | 977 | 8/31/2016 |
2.0.7.2 | 985 | 8/29/2016 |
2.0.7.1 | 978 | 8/29/2016 |
2.0.6.36 | 950 | 8/27/2016 |
2.0.6.32 | 956 | 8/27/2016 |
2.0.6.28 | 1,018 | 8/27/2016 |
2.0.6.26 | 1,005 | 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 |