A Helpful Database Library

using System;
using System.Data;
using System.Data.OleDb;
using System.Data.SqlClient;
using System.Collections.Generic;
using System.Text;
using MSDASC;
using ADODB;

namespace MyDatabaseLibrary
{
    public static class MyDatabase
    {
        public static void RunSqlCommands(MySqlData _MySQLData)
        {
            if (_MySQLData.MyDatabaseProvider == DatabaseProvider.MicrosoftJet)
            {
                OleDbConnection MyOleConn = new OleDbConnection(_MySQLData.MyConnectionString);
                OleDbCommand MyOleComm = new OleDbCommand(_MySQLData.MySQLString, MyOleConn);
                MyOleComm.Connection.Open();
                MyOleComm.ExecuteNonQuery();
                MyOleComm.Connection.Close();
            }
            else
            {
                SqlConnection MySqlConn = new SqlConnection(_MySQLData.MyConnectionString);
                SqlCommand MySqlComm = new SqlCommand(_MySQLData.MySQLString, MySqlConn);
                MySqlComm.Connection.Open();
                MySqlComm.ExecuteNonQuery();
                MySqlComm.Connection.Close();
            }
        }
        
        public static void GenerateConnectionString(ref MySqlData _MySqlData)
        {
            DataLinksClass MyDataLink = new DataLinksClass();
            Connection MyADOConn = (Connection)MyDataLink.PromptNew();                
            if (MyADOConn.Provider == "Microsoft.Jet.OLEDB.4.0")
            {
                _MySqlData.MyDatabaseProvider = DatabaseProvider.MicrosoftJet;
                _MySqlData.MyConnectionString = MyADOConn.ConnectionString;
            }
            else
            {
                _MySqlData.MyDatabaseProvider = DatabaseProvider.MicrosoftSQL;
                _MySqlData.MyConnectionString  = MyADOConn.ConnectionString;
                _MySqlData.MyConnectionString  = _MySqlData.MyConnectionString.Substring(
                    (_MySqlData.MyConnectionString.IndexOf(";") + 1),
                        (_MySqlData.MyConnectionString.Length - (
                            (_MySqlData.MyConnectionString.IndexOf(";") + 1))));
            }
        }

        public static DataTable GetDataTable(MySqlData _MySQLData)
        {
            DataTable MyDatatbl = new DataTable();
            if (_MySQLData.MyDatabaseProvider == DatabaseProvider.MicrosoftJet)
            {
                OleDbDataAdapter MyOleAdpt = new OleDbDataAdapter(_MySQLData.MySQLString, _MySQLData.                                          MyConnectionString);
                MyOleAdpt.Fill(MyDatatbl);
            }
            else if (_MySQLData.MyDatabaseProvider == DatabaseProvider.MicrosoftSQL)
            {
                SqlDataAdapter MySqlAdpt = new SqlDataAdapter(_MySQLData.MySQLString, _MySQLData.                                              MyConnectionString);
                MySqlAdpt.Fill(MyDatatbl);
            }
            return MyDatatbl;
        }

        public static DataTable GetDataBaseSchema(MySqlData _MySQLData)
        {
            DataTable MyDatatbl = new DataTable();
            if (_MySQLData.MyDatabaseProvider == DatabaseProvider.MicrosoftJet)
            {
                OleDbConnection OleConn = new OleDbConnection(_MySQLData.MyConnectionString);
                OleConn.Open();
                MyDatatbl = OleConn.GetSchema("Tables");
                OleConn.Close();
            }
            else if (_MySQLData.MyDatabaseProvider == DatabaseProvider.MicrosoftSQL)
            {
                SqlConnection SqlConn = new SqlConnection(_MySQLData.MyConnectionString);
                SqlConn.Open();
                MyDatatbl = SqlConn.GetSchema("Tables");
                SqlConn.Close();
            }
            return MyDatatbl;
        }
    }

    public class MySqlData
    {
        private string _MyConnectionString;
        private string _MySQLString;
        private DatabaseProvider _MyDatabaseProvider;

        public MySqlData()
        {

        }

        public string MyConnectionString
        {
            get
            {
                return _MyConnectionString;
            }
            set
            {
                _MyConnectionString = value;
            }
        }

        public string MySQLString
        {
            get
            {
                return _MySQLString;
            }
            set
            {
                _MySQLString = value;
            }
        }

        public DatabaseProvider MyDatabaseProvider
        {
            get
            {
                return _MyDatabaseProvider;
            }
            set
            {
                _MyDatabaseProvider = value;
            }
        }
    }

    public enum DatabaseProvider
    {
        MicrosoftJet=1,
        MicrosoftSQL,
        MySQL,
        Oracle
    }
}