luoyunchong/freekit

FreeKit为.NET Core提供了更多的扩展实现，包括FreeSql Repository 跨方法AOP事务、ASP.NET Core Identity的FreeSql存储、本地化的FreeSql实现

FreeKit

.NET YEARS

Freekit 为.NET Core提供了更多的扩展实现

英文 | 中文

Nuget Packages

Package name	Version	Downloads
IGeekFan.AspNetCore.Identity.FreeSql
IGeekFan.FreeKit
IGeekFan.FreeKit.Extras
IGeekFan.FreeKit.Modularity
IGeekFan.FreeKit.Email
IGeekFan.Localization.FreeSql
IGeekFan.Extensions.Diagnostics.HealthChecks.FreeSql
IGeekFan.AspNetCore.DataProtection.FreeRedis
IGeekFan.AspNetCore.DataProtection.FreeSql

BaGet Packages

Package name	Version
IGeekFan.AspNetCore.Identity.FreeSql	BaGet
IGeekFan.FreeKit	BaGet
IGeekFan.FreeKit.Extras	BaGet
IGeekFan.FreeKit.Modularity	BaGet
IGeekFan.FreeKit.Email	BaGet
IGeekFan.Localization.FreeSql	BaGet
IGeekFan.Extensions.Diagnostics.HealthChecks.FreeSql	BaGet
IGeekFan.AspNetCore.DataProtection.FreeRedis	BaGet
IGeekFan.AspNetCore.DataProtection.FreeSql	BaGet

IGeekFan.AspNetCore.Identity.FreeSql

asp.net core 6 的identity的freesql实现

• 查看IGeekFan.AspNetCore.Identity.FreeSql文档

IGeekFan.FreeKit

• AuditEntity 审计日志实体
• Dependency 依赖注入接口
• 查看IGeekFan.FreeKit文档

IGeekFan.FreeKit.Extras

• FreeSql扩展+Autofac UnitOfWork
• FreeSql+AuditEntity
• Autofac+ITransientDependency+IScopedDependency+ISingletonDependency
• CaseQuery
• Security 登录人信息
• 查看IGeekFan.FreeKit.Extras文档

IGeekFan.FreeKit.Email

• 基于MailKit实现的邮件IGeekFan.FreeKit.Email文档

IGeekFan.Localization.FreeSql

• 数据库多语言本地化IGeekFan.Localization.FreeSql文档

IGeekFan.FreeKit.Modularity

• 单体模块化IGeekFan.FreeKit.Modularity文档

freekit's Issues

FreeSql + DataProtection怎么使用？有文档和例子吗。

描述你希望的支持的新功能？
FreeSql + DataProtection怎么使用？有文档和例子吗。
项目用freeSql做orm。现在打算引入用Microsoft.AspNetCore.DataProtection。
由于多应用部署在docker上，密钥存储和共享就有点麻烦。
本地和注册表什么的就没戏，数据库的话不想引入EFCore，想直接使用FreeSql。目前是存储在redis中的。
你期望的 API 是怎样的？

AuditRepository 仓储软删除 会清空数据

重现步骤（可选）：

该重载接口存在清空除删除字段相关的数据，该参数未直接查询数据，需要Attach

   await Repository.DeleteAsync(new Doc { Id = id });

AOP 给当前审计日志赋值

AOP审计日志赋值

安装包IGeekFan.FreeKit.Extras

dotnet add package IGeekFan.FreeKit.Extras

增加扩展

public static class CurrentUserExtensions
{
    public static Guid? FindUserId(this ICurrentUser currentUser)
    {
        return currentUser.FindUserIdToGuid();
    }
}

给FreeSql 的AOP AuditValue赋值

public static class ServiceCollectionExtensions
{
    public static void AuditValue(AuditValueEventArgs e, ICurrentUser? user)
    {
        if (e.AuditValueType == AuditValueType.Insert)
        {
            if (e.Column.CsName == "CreateUserId")
            {
                e.Value = user?.FindUserId();
            }
            if (e.Column.CsName == "CreateUserName")
            {
                e.Value = user?.UserName;
            }
            if (e.Column.CsName == "CreateTime")
            {
                e.Value = DateTime.Now;
            }
            if (e.Column.CsName == "TenantId")
            {
                e.Value = user?.TenantId;
            }
        }
        else if (e.AuditValueType == AuditValueType.Update)
        {
            if (e.Column.CsName == "UpdateUserId")
            {
                e.Value = user?.FindUserId();
            }
            if (e.Column.CsName == "UpdateUserName")
            {
                e.Value = user?.UserName;
            }
            if (e.Column.CsName == "UpdateTime")
            {
                e.Value = DateTime.Now;
            }
        }
    }

  public static IServiceCollection AddFreeSql(this IServiceCollection services, IConfiguration configuration)
  {
      services.AddCurrentUserAccessor();
      IFreeSql fsql = new FreeSqlBuilder()
                 .UseConnectionString(configuration)
                .UseNameConvert(NameConvertType.PascalCaseToUnderscoreWithLower)
                .UseAutoSyncStructure(true) //自动同步实体结构到数据库，FreeSql不会扫描程序集，只有CRUD时才会生成表。
                .UseMonitorCommand(cmd =>
                {
                    Trace.WriteLine(cmd.CommandText + ";");
                })
                .Build();
      var provider = services.BuildServiceProvider();
      var currentAccessor = provider.GetRequiredService<ICurrentUserAccessor>();
      
      fsql.GlobalFilter.ApplyOnly<ISoftDelete>("IsDeleted", a => a.IsDeleted == false);
      fsql.GlobalFilter.ApplyOnlyIf<ITenant>("TenantId", () => currentAccessor.CurrentUser?.TenantId != null, a => a.TenantId == currentAccessor.CurrentUser.TenantId);
      
      fsql.Aop.AuditValue += (s, e) =>
      {
                  AuditValue(e, currentAccessor.CurrentUser);
      };
      
      services.AddSingleton<IFreeSql>(fsql);
      services.AddFreeRepository();
      services.AddScoped<UnitOfWorkManager>();
      
      return services;
  }
}

引用服务

builder.Services.AddFreeSql(builder.Configuration);

中间件

//自定义中间件，给ICurrentUserAccessor中的CurrentUser赋值
app.UseCurrentUserAccessor();

appsettings.json配置

 "ConnectionStrings": {
    "DefaultDB": "4",
    "MySql": "Data Source=localhost;Port=3306;User ID=root;Password=root;Initial Catalog=freekit;Charset=utf8mb4;SslMode=none;Max pool size=1;Connection LifeTime=20",
    "SqlServer": "Data Source=.;User ID=sa;Password=123456;Integrated Security=True;Initial Catalog=LinCMS;Pooling=true;Min Pool Size=1",
    "PostgreSQL": "Host=localhost;Port=5432;Username=postgres;Password=123456; Database=lincms;Pooling=true;Minimum Pool Size=1",
    "Oracle": "user id=root;password=root; data source=//127.0.0.1:1521/ORCL;Pooling=true;Min Pool Size=1",
    "Sqlite": "Data Source=Identity.db"
  },

FreeSql ORM 一个数据库中存在多个Provider实现，都安装时根据配置决定使用哪个驱动

描述你希望的支持的新功能？
FreeSql ORM 一个数据库中存在多个Provider实现，都安装时根据配置决定使用哪个驱动

UseConnectionString 扩展方法支持具体哪一个provider

FreeSql.Provider.MySql
FreeSql.Provider.MySqlConnector

你期望的 API 是怎样的？