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

[luoyunchong]

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

[luoyunchong]

使用方式和微软EFCore应该差不多 https://learn.microsoft.com/zh-cn/aspnet/core/security/data-protection/implementation/key-storage-providers?view=aspnetcore-7.0&tabs=visual-studio#entity-framework-core

1.FreeSql单例注册等

        IFreeSql fsql = new FreeSqlBuilder()
                 .UseConnectionString(....)
                 .UseAutoSyncStructure(true)
                 .UseNameConvert(NameConvertType.PascalCaseToUnderscoreWithLower)
                 .UseGenerateCommandParameterWithLambda(true)//默认false,针对 lambda 表达式解析,设置成true时方便查看SQL
                 .UseNoneCommandParameter(true) //默认true,针对insert/update/delete是否参数化
                 .UseMonitorCommand(
                     cmd => Trace.WriteLine("\r\n线程" + Thread.CurrentThread.ManagedThreadId + ": " + cmd.CommandText)
               ).Build();

        services.AddSingleton(fsql);
        services.AddFreeKitCore();

        services.AddFreeDbContext<DataProtectionKeyContext>(options =>
                 options.UseFreeSql(fsql).UseOptions(
                     new DbContextOptions()
                     {
                         EnableCascadeSave = true
                     })
             );

2 定义DbContext

• https://github.com/luoyunchong/FreeKit/blob/main/test/IGeekFan.AspNetCore.DataProtection.FreeSql.Tests/DataProtectionKeyContext.cs

public class DataProtectionKeyContext : DbContext, IDataProtectionKeyContext
{
    public DataProtectionKeyContext(IFreeSql fsql, DbContextOptions options) : base(fsql, options) { }

    public DbSet<DataProtectionKey> DataProtectionKeys { get; set; }
}

    // using Microsoft.AspNetCore.DataProtection;
    services.AddDataProtection()
        .PersistKeysToDbContext<DataProtectionKeyContext>();

3.Dataprotection具体方法使用，直接看官方文档，我也没用过，只是写了下单元测试

FreeKit/samples/IGeekFan.FreeKit.Web/Controllers/TestController.cs

Line 43 in 80db99c

public string DataProtect(string input)