2023年7月18日发(作者：)

ABPnetcore多数据库连接,动态链接字符串ABP netcore多数据库连接,动态链接字符串829363738394041public class MyConnectionStringResolver:DefaultConnectionStringResolver { private readonly IConfigurationRoot _appConfiguration; public ssion AbpSession { get; set; } private readonly ICurrentUnitOfWorkProvider _currentUnitOfWorkProvider; private readonly Manager _tenantManager; public MyConnectionStringResolver(IAbpStartupConfiguration configuration, IHostingEnvironment hostingEnvironment, ICurrentUnitOfWorkProvider currentUnitOfWorkProvider, Manager tenantManager ) : base(configuration) { _appConfiguration = (tRootPath, nmentName); _currentUnitOfWorkProvider = currentUnitOfWorkProvider; AbpSession = ce; _tenantManager = tenantManager; } public override string GetNameOrConnectionString(ConnectionStringResolveArgs args) { if (args["DbContextConcreteType"] as Type == typeof(ndContext)) { var tenant = _d(GetCurrentTenantId().GetValueOrDefault()); var str= "Server=" + seServer + "; Database=" + seName + "; Uid=" + seUid + ";Password=" + tenant return str; } return eOrConnectionString(args); } protected virtual int? GetCurrentTenantId() { return _t != null ? _antId() : Id; } }注意事项：因为涉及到sql2000和sql2005在使⽤ABP分页时会有问题，所以在DbSecondContextOptionsConfigurer中：1112public class DbSecondOptionsConfigurer { public static void Configure(DbContextOptionsBuilder builder, string connectionString) { } public static void Configure(DbContextOptionsBuilder builder, DbConnection connection) { } }` Server(connectionString, b => NumberForPaging());//后⾯半句解决sql2005、sql2008：不⽀持在 FETCH

语句中选项 NEXT

Server(connection, b => NumberForPaging());//后⾯半句解决sql2005、sql2008：不⽀持在 FETCH

语句中选项 NEXT

的⽤法花了好⼏天研究。第⼀次写不⾜之处见谅。