"ConnectionStrings": {
//自己的數據庫
"Connstr": "server=.;uid=sa;pwd=123456;database=CAP1108;TrustServerCertificate=True",
//Cap數據庫
"OrderCap": "server=.;uid=sa;pwd=123456;database=OrderCap;TrustServerCertificate=True"
}

Func<IServiceProvider, IFreeSql> fsqlFactory = r =>
{
    IFreeSql fsql = new FreeSql.FreeSqlBuilder()
        .UseConnectionString(FreeSql.DataType.SqlServer, builder.Configuration.GetConnectionString("Connstr"))
        .UseLazyLoading(true)
        //.UseMonitorCommand(cmd => Console.WriteLine($"Sql：{cmd.CommandText}"))//監聽SQL語句
        .UseAutoSyncStructure(true) //自動同步實體結構到數據庫，FreeSql不會掃描程序集，只有CRUD時才會生成表。
        .Build();
    return fsql;
};

//在項目啟動時，從容器中獲取IFreeSql實例，并執行一些操作：同步表，種子數據, FluentAPI等
using (IServiceScope serviceScope = app.Services.CreateScope())
{
    var fsql = serviceScope.ServiceProvider.GetRequiredService<IFreeSql>();
    fsql.CodeFirst.SyncStructure(typeof(UserInfo));//Topic 為要同步的實體類
}