FBW.DotNet.AspNetCore 1.0.6

FBW.DotNet.AspNetCore

ASP.NET Core扩展包，目前支持.NET3.1,.NET5,.NET6,.NET7,.NET8

如何使用

1、安装FBW.DotNet.AspNetCore依赖。
Cmd install：

dotnet add package FBW.DotNet.AspNetCore

2、在Startup.cs中配置

//Identity相关配置  支持MySql,SqlServer,PostgreSql
builder.Services.AddDefaultIdentityConfiguration().AddIdentityServerStore<MyDbContext>(options =>
{
    options.ConfigureDbContext = op =>
    {
        op.UseNpgsql(configuration["SystemConfig:DBConnectionString"], s => s.MigrationsAssembly("DotNet.Domain"))
        .UseSnakeCaseNamingConvention();
        //.EnableSensitiveDataLogging();
        // 配置日志输出
        //op.LogTo(Console.WriteLine);
    };
    options.PrivateKey = configuration["SystemConfig:PrivateKey"];
    options.RedisOptions = configuration.GetSection("RedisConfig").Get<RedisOptions>();//为空不启动redis缓存
    options.WorkerThreads = 100;
    options.CompletionPortThreads = 100;
}).AddResourceOwnerValidator<ResourceOwnerPasswordValidator>();

//多租户  TenantDbContext ef的租户DbContext上下文
//迁移多租户上下文
//Add-Migration InitialCreate -Context MyDbContext -OutputDir Migrations\SqlServer -Args "--provider SqlServer"
//Add-Migration InitialCreate -Context MyDbContext -OutputDir Migrations\MySql -Args "--provider MySql"
//Add-Migration InitialCreate -Context MyDbContext -OutputDir Migrations\PostgreSql -Args "--provider PostgreSql"
//update-database -Args "--provider MySql"
//update-database -Args "--provider SqlServer"
//update-database -Args "--provider PostgreSql"
builder.Services.AddDbContextMultiTenancy<TenantDbContext>(options => {
    options.UseNpgsql(configuration["SystemConfig:DBConnectionString"]).UseSnakeCaseNamingConvention();
});

//如果要同时支持不同的数据库
var provider = builder.Configuration.GetValue("Provider", "PostgreSql");
var tenantDBConfig = builder.Configuration.GetSection("SystemConfig:MultiTenantDBConfig").Get<List<MultiTenantDBConfig>>()?.FirstOrDefault(t=>t.DBProvider.ToString()== provider);
builder.Services.AddDbContextMultiTenancy<TenantDbContext>(options =>
{
    if (tenantDBConfig == null) 
    {
        throw new ArgumentException("配置异常");
    }
    options.ReplaceService<IMigrationsAssembly, EFCoreMultiDatabaseMigrationsAssembly>();
    _ = provider switch
    {
        "PostgreSql" => options.UseNpgsql(tenantDBConfig.DBConnectionString).UseSnakeCaseNamingConvention()
        .UseMigrationNamespace(new PostgreSqlMigrationNamespace()),
        "SqlServer" => options.UseSqlServer(tenantDBConfig.DBConnectionString)
        .UseMigrationNamespace(new SqlServerMigrationNamespace()),
        "MySql" => options.UseMySql(tenantDBConfig.DBConnectionString,ServerVersion.AutoDetect(tenantDBConfig.DBConnectionString))
        .UseMigrationNamespace(new MySqlMigrationNamespace()),
        _ => throw new Exception($"Unsupported provider: {provider}")
    };
});

重写GetDirectory 不进行深度检查
using System;
using System.Reflection;
using System.Text;
using Microsoft.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore.Design;
using Microsoft.EntityFrameworkCore.Infrastructure;
using Microsoft.EntityFrameworkCore.Internal;
using Microsoft.EntityFrameworkCore.Migrations;
using Microsoft.EntityFrameworkCore.Migrations.Design;
using Microsoft.EntityFrameworkCore.Migrations.Operations;
using Newtonsoft.Json;
using System.IO;

namespace DotNet.Admin.Web
{
    public class MyMigrationsScaffolder: MigrationsScaffolder
    {
        private readonly Type _contextType;
        public MyMigrationsScaffolder(MigrationsScaffolderDependencies dependencies) : base(dependencies)
        {
            _contextType = dependencies.CurrentContext.Context.GetType();
        }
        protected override string GetDirectory(string projectDir, string? siblingFileName, string subnamespace)
        {
            var defaultDirectory = Path.Combine(projectDir, Path.Combine(subnamespace.Split('.')));

            if (siblingFileName != null)
            {
                if (!siblingFileName.StartsWith(_contextType.Name + "ModelSnapshot."))
                {
                    var siblingPath = TryGetProjectFile(projectDir, siblingFileName);
                    if (siblingPath != null)
                    {
                        var lastDirectory = Path.GetDirectoryName(siblingPath)!;
                        if (!defaultDirectory.Equals(lastDirectory, StringComparison.OrdinalIgnoreCase))
                        {
                            Dependencies.OperationReporter.WriteVerbose(DesignStrings.ReusingNamespace(siblingFileName));

                            return lastDirectory;
                        }
                    }
                }
            }

            return defaultDirectory;
        }
    }
}

using Microsoft.EntityFrameworkCore.Design;
using Microsoft.EntityFrameworkCore.Migrations.Design;
using Microsoft.Extensions.DependencyInjection;

namespace DotNet.Admin.Web
{
    /// <summary>
    /// https://docs.microsoft.com/en-us/ef/core/cli/services
    /// </summary>
    public class MyMigrationDesignTimeServices: IDesignTimeServices
    {
        public void ConfigureDesignTimeServices(IServiceCollection serviceCollection)
        {
            serviceCollection.AddSingleton<IMigrationsScaffolder, MyMigrationsScaffolder>();
        }
    }
}
![Image text](https://img2022.cnblogs.com/blog/1346660/202207/1346660-20220725164440985-659409126.png)





//jwt相关配置
builder.Services.AddDotNetJwtBearerAuthentication(configuration["SystemConfig:PublicKey"],configuration["SystemConfig:ValidIssuer"]);

//Mvc相关配置
builder.Services.AddDotNetDefaultMvc();

//SwaggerDoc配置
builder.Services.Configure<SwaggerConfig>(configuration.GetSection("SwaggerConfig"));
builder.Services.AddSwaggerDoc(configuration.GetSection("SwaggerConfig").Get<SwaggerConfig>());

var app = builder.Build();

//添加多租户中间件 
//1,支持从token中解析TenantId字段(CurrentTokenTenantResolveContributor)
//2,从请求头中解析TenantId字段(CurrentHeaderTenantResolveContributor)
//3,从地址栏中解析TenantId字段(CurrentQueryTenantResolveContributor)
//4,扩展解析策略继承TenantResolveContributorBase抽象类型 ,以单例模式注入
//租户访问器ICurrentTenantAccessor
app.UseDotNetDefaultMvc();
app.UseSwaggerUI(configuration.GetSection("SwaggerConfig").Get<SwaggerConfig>());
app.UseIdentityServer();

//初始化多租户数据库
app.Services.InitTenantDatabase<TenantDbContext>();

3、 appsettings.json配置文件实例：

{
   //接口文档配置
  "SwaggerConfig": {
    "Title": "DotNet.Admin.Web",
    "Version": "v1",
    "Description": "DotNet.Admin.Web",
    "Name": "DotNet",
    "Email": "2231030106@qq.com",
    "ProxyRoutes": {
      //"localhost": "http://127.0.0.1:6033/IdentityServer"
    },
    "RoutePrefix": "help",
    "IsAdminHelpUI": true,
    "AdminSecret": "admin",
    "IsSwaggerBasicAuth": false
  },
  //redis 配置
  "RedisConfig": {
    "Connection": "127.0.0.1:6379,password=123456",
    "KeyPrefix": "dotnetadminweb",
    "DefaultDatabase": 0,
    "DataProtecteKey": "DotNet.Admin.Web:DataProtection-Keys",
    "IsSentinel": false, // 是否哨兵模式
    "SentinelConfig": {
        "DefaultDatabase": "4",
        "EndPoints": [ // 哨兵端口
        // "10.10.0.124:26380"
        ],
        "Password": "123456",
        "SentinelPassword": "123456",
        "ServiceName": "dotnetadminweb"
    }
  },
   //系统配置
  "SystemConfig": {
    "ValidIssuer": "https://localhost:44354",
    "DatabaseVisitLogSleep": 10000,//系统日志入库时间
    "DBConnectionString": "Host=127.0.0.1;Username=postgres;Password=123456;Database=DotNet_Template",
    //多租户模式下同时支持不同的数据库集合,仅开发迁移多租户不同数据库时需要配置
    "MultiTenantDBConfig": [
      {
        "DBProvider": "PostgreSql",
        "DBConnectionString": "Host=127.0.0.1;Username=postgres;Password=123456;Database=DotNet_Template_470786554998853"
      },
      {
        "DBProvider": "SqlServer",
        "DBConnectionString": "Data Source=.;Initial Catalog=DotNet_Template_470786554998853;User Id=sa;Password=123456;Encrypt=True;TrustServerCertificate=True"
      }
    ],
    "PublicKey": "MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAiQPMKq+BQIhoImH30v8FH02x8S8Bz6+ROwzidBEk8C2BidnnMFs2OeXQeHRW7HSJRAhTVTBwhWoJ+3G/C2L6FiMLYPgaKpWsacqZPkbcgpHKfQLJn1weXeZqLNeZKi+aebOX27JOt9cph/YVb5hBTgVzl5q7yASOEg9+wV/y1d8Jq4EAlzXdAux+JRgMGQgj8CSPSSY1z2PO4iZProdgFa/dto8AlVRabVCTx6BoCnMrImy2XRHdF0Ue0eY5mtAAsnLudjKqm8AUopMOivNCLVI5eXzMIoMmpa0bUj7IluoushYVLY0dw7flyKldiDbyvi4w/jrxHRruNMb11fNEFQIDAQAB",
    "PrivateKey": "MIIEowIBAAKCAQEAiQPMKq+BQIhoImH30v8FH02x8S8Bz6+ROwzidBEk8C2BidnnMFs2OeXQeHRW7HSJRAhTVTBwhWoJ+3G/C2L6FiMLYPgaKpWsacqZPkbcgpHKfQLJn1weXeZqLNeZKi+aebOX27JOt9cph/YVb5hBTgVzl5q7yASOEg9+wV/y1d8Jq4EAlzXdAux+JRgMGQgj8CSPSSY1z2PO4iZProdgFa/dto8AlVRabVCTx6BoCnMrImy2XRHdF0Ue0eY5mtAAsnLudjKqm8AUopMOivNCLVI5eXzMIoMmpa0bUj7IluoushYVLY0dw7flyKldiDbyvi4w/jrxHRruNMb11fNEFQIDAQABAoIBADoBSpETpfONDBDqSsGfxypeeSOzE+A54pEOPlyG2Y14pmuWvYJCSy2ttlkYX6hRGb+cirL5A9nnb3xsxkVqzJdMlMejoWg/3zMWW1P7KeV5FTFhWbxGgnCcWHzNdYFfj9VQC80tqpe31lRCAQcyfQsr0ajwD+l4zDCnMLFrDmIuICDFz29wMQC72t8TPCE4dykw8vr5LnKf3aJyh5ScrsNyry73Oiq2X48xadZ2Dh4TW9v5DgBDTiOlsWmXaZbNg8nlJh6MjMTbe7CO9w3ge95liz5XE/CrhR5RWJmiOY8MudvIEov1CQlVMUI11RG8mRKV5qs0Ma+5E2QEMtPWzEECgYEAzc1NxqDoqO9IgGOWRheT2i6vOJEsaeeN4u/E9bm0nYDtsLS9Dg1liSJkze2nTqpEAA1iFt79n3M0fD8CXDWcleGxF7ZeDM0xuN91FAoY4XkZFZaEi8hlsOmZ6A7qusgQQi19Win50CSdgp1Snc7Y0UBXLnvjMZJ8CjQQItL9hhECgYEAqm9IxO9pm+OdrwYD/ZpKypDzm2w7EqZi7LD4J8d63H0t/tIO1Zrxy5qKQOu8XMbkwQjVykPyZJHOd+8ICrKFbfn7xjxqPvW9h809/9jfYY3RLMhKtaDJ7ktwJxVtGmjO+PEft4RGoLmEfbrTSnarasBY99njhKNG8FtTc75cicUCgYEAwdGdcvhtxVP9SvT/PKnN1Ahteu+2DVNG3DgFnYo0oLUgpW/CMO7K9jjPCOXN0JcoDYiNHY8K+tUL1AufVGolOz7fgr58mr/RGRRR9fqAbjCXQC6OS/sCUnfeO594z0nFjh27VWP84lrpgG5btUVuCrv2n0+Lq08SxKU9oR5mJ5ECgYBnPEs2xtIQlBoCV0F5jsj41D5LCY7qqBBJ0JQv/DumbMi8jl5f8p+9tVlDI8eP5wXPC1v8TZX4Zv1KVmZnnGUIDaD9HcE5a76nEKIaZDJCtBVc6+GdDMzj45wGgIr6sTuVPPD6R0xEtLrVMaIke6cvXV1GnBudTw18L8Vn2YnSBQKBgG/NxXjh+urIa+qsIzNHbrTCt+qGsix8z1f7s1OwTlVksFW3otaNK2hIDMlslUgRnVzjZfPyzKME/EuA/WjqAn/ZxqDR1TYvgxil8EaBn9jTEL7LO06ggCuh1dnmPrzC06no5E6Gj4m+6tknO5K5/NU/2HqQnaR6IB514ut7URba"
  }
}

4、Efcore迁移

add-migration Ids4Config001 -c IdentityContext -o Migrations/Ids4Config