Fast.Framework ORM 试用
简介Fast.Framework 是一款基于 .NET 6 封装的轻量级ORM框架，支持多种数据库(SQL Server、Oracle、MySQL、PostgreSQL、SQLite)。
优点
[*]性能好
[*]使用简单
如何使用
1. 安装
NuGet搜索Fast.Framework并安装最新版本
https://img2022.cnblogs.com/blog/174862/202209/174862-20220916124410792-1246549512.png
2. 创建DbContext对象
DbContext是轻量级的，可以频繁创建，一个线程创建一个DbContext，不要跨线程使用。
private IDbContext GetDbContext()
{
IDbContext _db = new DbContext(new List<DbOptions>() {
new DbOptions()
{
DbId = "1",
DbType = DbType.MySQL,
ProviderName = "MySqlConnector",
FactoryName = "MySqlConnector.MySqlConnectorFactory,MySqlConnector",
ConnectionStrings = "Data Source=localhost;Port=3306;User ID=root;Password=123456;Initial Catalog=fast_framework_test;Charset=utf8mb4;SslMode=none;Allow User Variables=True;connection timeout=600;"
}
});
if (_printSql)
{
_db.Aop.DbLog = (sql, dp) =>
{
Console.WriteLine($"执行Sql:{sql}");
if (dp != null)
{
foreach (var item in dp)
{
Console.WriteLine($"参数名称:{item.ParameterName} 参数值:{item.Value}");
}
}
};
}
return _db;
}实体类
实体类原生支持微软特性，兼容Entity Framework。
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
namespace Models
{
/// <summary>
/// 用户表
/// </summary>
public partial class SysUser
{
/// <summary>
/// 主键
/// </summary>
public long Id { get; set; }
/// <summary>
/// 用户名
/// </summary>
public string UserName { get; set; }
/// <summary>
/// 用户姓名
/// </summary>
public string RealName { get; set; }
/// <summary>
/// 用户密码
/// </summary>
public string Password { get; set; }
/// <summary>
/// 备注
/// </summary>
public string Remark { get; set; }
/// <summary>
/// 创建者ID
/// </summary>
public string CreateUserid { get; set; }
/// <summary>
/// 创建时间
/// </summary>
public DateTime CreateTime { get; set; }
/// <summary>
/// 更新者ID
/// </summary>
public string UpdateUserid { get; set; }
/// <summary>
/// 更新时间
/// </summary>
public DateTime? UpdateTime { get; set; }
}
}.NET 6 依赖注入FastDbContext
配置文件
"DbConfig": [
{
"DbId": 1,
"DbType": "MySQL",
"IsDefault": true,
"ProviderName": "MySqlConnector",
"FactoryName": "MySqlConnector.MySqlConnectorFactory,MySqlConnector",
"ConnectionStrings": "Data Source=localhost;Port=3306;User ID=root;Password=123456;Initial Catalog=fast_framework_test;Charset=utf8mb4;SslMode=none;Allow User Variables=True;connection timeout=600;"
}
]注入代码
//注入FastDbContext
builder.Services.Configure<List<DbOptions>>(builder.Configuration.GetSection("DbConfig"));
builder.Services.AddFastDbContext();循环插入
await db.Ado.BeginTranAsync();
foreach (SysUser user in userList)
{
await db.Insert(user).ExceuteAsync();
}
await db.Ado.CommitTranAsync();批量插入
await GetDbContext().Insert(userList).ExceuteAsync();循环修改
await db.Ado.BeginTranAsync();
foreach (SysUser user in userList)
{
await db.Update(user).ExceuteAsync();
}
await db.Ado.CommitTranAsync();批量修改
await GetDbContext().Update(userList).ExceuteAsync();条件查询
Pagination pagination = new Pagination();
pagination.Page = 10;
pagination.PageSize = 200;
var list = await _db.Query<SysUser>()
.Where(t => t.Id > 20 && t.RealName.Contains("测试"))
.OrderBy(t => t.CreateTime, "desc")
.OrderBy(t => t.Id).ToPageListAsync(pagination);分组聚合统计查询
这个写法很优雅。
var list = await db.Query<BsOrderDetail>()
.LeftJoin<BsOrder>((d, o) => o.Id == d.OrderId)
.GroupBy((d, o) => new { o.Id, o.OrderTime, o.Remark })
.Having((d, o) => SqlFunc.Sum(d.Quantity * d.Price) > 1000)
.Select((d, o) => new
{
o.Id,
o.OrderTime,
o.Remark,
Amount = SqlFunc.Sum(d.Quantity * d.Price)
}).ToListAsync();性能测试
性能测试使用Winform测试
与其它ORM的对比请参考《ORM增删改查并发性能测试2》
常规测试
https://img2022.cnblogs.com/blog/174862/202209/174862-20220916145756922-269498237.png
并发查询
https://img2022.cnblogs.com/blog/174862/202209/174862-20220916150021130-2060312120.png
并发插入
https://img2022.cnblogs.com/blog/174862/202209/174862-20220916150130031-1962960539.png
结论
感觉还是非常快的，性能非常优异。
免责声明：如果侵犯了您的权益，请联系站长，我们会及时删除侵权内容，谢谢合作！
页:
[1]