gistfile1.cs

namespace MahBalls
{
    using System;
    using System.Data.Common;
    using MySql.Data.MySqlClient;
    using System.Collections.Generic;

    public class DataManager : IDisposable
    {
        private bool disposed = false;
        private DbConnection connection;
        private ILog logger;

        public DataManager(string connectionString)
        {
            connection = new MySqlConnection(connectionString);
            connection.Open();
        }

        public void Dispose()
        {
            Dispose(true);
            GC.SuppressFinalize(this);
        }

        private void Dispose(bool disposing)
        {
            if (!disposed)
            {
                if (disposing)
                {
                    connection.Close();
                    connection.Dispose();
                }

                connection = null;
                disposed = true;
            }
        }
    }
}