abp 动态切换连接字符串并执行sql

abp 动态切换连接字符串并执行sql

仓储层

            // 创建 DbContextOptionsBuilder 实例
            var optionsBuilder = new DbContextOptionsBuilder<MicroServiceDbContext>();

            // 设置连接字符串
            optionsBuilder.UseSqlServer("User ID=sa;Initial Catalog=;Data Source=;Password=;Connection Lifetime=60000;Encrypt=false;");

            // 使用 optionsBuilder 构建 DbContext 实例并进行数据库操作
            using var dbContext = new MicroServiceDbContext(optionsBuilder.Options);

            var sql = $"INSERT INTO [dbo]......";
            var formattableSql = FormattableStringFactory.Create(sql);
            dbContext.Database.ExecuteSql(formattableSql);