asp.net操作两个数据库

<connectionStrings>
  <add name="DB1" connectionString="Data Source=server1;Initial Catalog=db1;Integrated Security=True" providerName="System.Data.SqlClient" />
  <add name="DB2" connectionString="Data Source=server2;Initial Database=db2;User ID=user;Password=password" providerName="System.Data.SqlClient" />
</connectionStrings>

using (var context1 = new DbContext(new DbContextOptionsBuilder().UseSqlServer(Configuration.GetConnectionString("DB1")).Options))
{
    // 操作 DB1
}

using (var context2 = new DbContext(new DbContextOptionsBuilder().UseSqlServer(Configuration.GetConnectionString("DB2")).Options))
{
    // 操作 DB2
}

using (var scope = new TransactionScope())
{
    using (var connection1 = new SqlConnection(Configuration.GetConnectionString("DB1")))
    {
        connection1.Open();
        // 执行 DB1 操作
    }

    using (var connection2 = new SqlConnection(Configuration.GetConnectionString("DB2")))
    {
        connection2.Open();
        // 执行 DB2 操作
    }

    scope.Complete();
}

public class HomeController : Controller
{
    private readonly ApplicationDbContext _context1;
    private readonly AnotherDbContext _context2;

    public HomeController(ApplicationDbContext context1, AnotherDbContext context2)
    {
        _context1 = context1;
        _context2 = context2;
    }

    public async Task<IActionResult> Index()
    {
        var data1 = await _context1.Data.ToListAsync();
        var data2 = await _context2.MoreData.ToListAsync();

        // 处理数据

        return View();
    }
}