using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using MySql.Data.MySqlClient;

namespace Bug25907Cis
{
    class Program
    {
        static void Main()
        {
            string connectionString = GetConnectionString();
            using (MySqlConnection connection =
               new MySqlConnection(connectionString))
            {
                connection.Open();
                string[] restrictions = new string[4];
                DataTable table = connection.GetSchema("DataTypes", new string[] { });
                // Display the contents of the table.
                DisplayData(table);
                Console.WriteLine("Press any key to continue.");
                Console.ReadKey();
            }
        }

        private static string GetConnectionString()
        {
            return "DataSource=localhost;Database=test;UserID=root;Password=;PORT=3306";//allow batch=False";
        }

        private static void DisplayData(System.Data.DataTable table)
        {
            foreach (System.Data.DataRow row in table.Rows)
            {
                foreach (System.Data.DataColumn col in table.Columns)
                {
                    Console.WriteLine("{0} = {1}", col.ColumnName, row[col]);
                }
                Console.WriteLine("============================");
            }
        }
    }
}