如何使用Autofac for Dapper创建IDbConnection工厂？

public class DbConnectionFactory : IDbConnectionFactory
{
    private readonly string _connectionString;

    public DbConnectionFactory(string connectionString)
    {
        _connectionString = connectionString;
    }

    public IDbConnection CreateConnection()
    {
        return new SqlConnection(_connectionString);
    }
}

var builder = new ContainerBuilder();

// 注册IDbConnectionFactory
builder.RegisterType<DbConnectionFactory>()
       .As<IDbConnectionFactory>()
       .WithParameter("connectionString", "your_connection_string_here");

// 注册其他依赖项...

// 构建容器
var container = builder.Build();

public class MyRepository
{
    private readonly IDbConnectionFactory _connectionFactory;

    public MyRepository(IDbConnectionFactory connectionFactory)
    {
        _connectionFactory = connectionFactory;
    }

    public void DoSomething()
    {
        using (var connection = _connectionFactory.CreateConnection())
        {
            // 使用connection执行数据库操作
        }
    }
}