使用StructureMap对具有多个数据库字符串的DAL进行依赖注入

public class StructureMapConfig : Registry
{
    public StructureMapConfig()
    {
        // 注册DAL接口和实现类的映射关系
        For<IDatabase>().Use<SqlServerDatabase>().Named("SqlServer");
        For<IDatabase>().Use<MySqlDatabase>().Named("MySql");
        
        // 配置多个数据库连接字符串
        For<SqlConnection>().Use(() => new SqlConnection("SqlServerConnectionString")).Named("SqlServer");
        For<MySqlConnection>().Use(() => new MySqlConnection("MySqlConnectionString")).Named("MySql");
    }
}

public class Program
{
    public static void Main(string[] args)
    {
        // 初始化StructureMap容器
        var container = new Container(cfg =>
        {
            cfg.AddRegistry(new StructureMapConfig());
        });
        
        // 从容器中解析出DAL实例
        var sqlServerDal = container.GetInstance<IDatabase>("SqlServer");
        var mySqlDal = container.GetInstance<IDatabase>("MySql");
        
        // 使用DAL实例进行数据库操作
        sqlServerDal.Execute("SELECT * FROM Table");
        mySqlDal.Execute("SELECT * FROM Table");
    }
}