Connection Lifetime Manager

ConnectionLifetimeManager.cs

public class ConnectionLifetimeManager : IDisposable
{
    private readonly IDbConnection connection;
    private readonly bool needsClosed;

    public ConnectionLifetimeManager(IDbConnection connection)
    {
        this.connection = connection;
        if (connection.State == ConnectionState.Closed)
        {
            connection.Open();
            needsClosed = true;
        }
    }

    public void Dispose()
    {
        if (needsClosed)
        {
            connection.Close();
        }
    }
}