使用Entity Framework将相同的更改保存到多个数据库

public class MyDbContext : DbContext
{
    public DbSet<MyEntity> MyEntities { get; set; }

    protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
    {
        // 配置第一个数据库连接
        optionsBuilder.UseSqlServer("FirstConnectionString");
    }
}

public class MySecondDbContext : DbContext
{
    public DbSet<MyEntity> MyEntities { get; set; }

    protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
    {
        // 配置第二个数据库连接
        optionsBuilder.UseSqlServer("SecondConnectionString");
    }
}

public class MyEntity
{
    public int Id { get; set; }
    public string Name { get; set; }
}

public void SaveChangesToMultipleDatabases(MyEntity entity)
{
    using (var context1 = new MyDbContext())
    using (var context2 = new MySecondDbContext())
    {
        // 在第一个数据库上下文中添加实体
        context1.MyEntities.Add(entity);
        context1.SaveChanges();

        // 在第二个数据库上下文中添加相同的实体
        context2.MyEntities.Add(entity);
        context2.SaveChanges();
    }
}