using MySql.Data.MySqlClient;
using System;
using System.Data;

namespace Arch.Data.FuncTest
{
    class Program
    {
        static void Main(string[] args)
        {
            //dummy code
            String connectionString = "";
            String sql = "select 1";
            IDbConnection con = null;

            try
            {
                using (con = new MySqlConnection(connectionString))
                {
                    con.Open();
                    using (IDbCommand com = con.CreateCommand())
                    {
                        com.CommandText = sql;
                        using (IDataReader reader = com.ExecuteReader())
                        {
                            while (reader.Read())
                            {

                            }
                        }

                    }
                }
            }
            catch (Exception)
            {
                if (con != null)
                    con.Close();
            }

            using (con = new MySqlConnection(connectionString))
            {
                con.Open();
                using (IDbCommand com = con.CreateCommand())
                {
                    com.CommandText = sql;
                    using (IDataReader reader = com.ExecuteReader())
                    {
                        while (reader.Read())
                        {

                        }
                    }

                }
            }

        }
    }
}