public IDatabaseHandler CreateDatabase()
        {
            IDatabaseHandler database = null;

            switch (connectionStringSettings.ProviderName.ToLower())
            {
            case "system.data.sqlclient":
                database = new SqlServerDataAccess(connectionStringSettings.ConnectionString);
                break;

            case "system.data.mysqlclient":
                database = new MySqlDataAccess(connectionStringSettings.ConnectionString);
                break;
            }

            return(database);
        }
        public IDatabaseHandler CreateDatabase()
        {
            IDatabaseHandler database = null;

            switch (connectionStringSettings.ProviderName.ToLower())
            {
            case "system.data.sqlclient":
                database = new SqlDataAccess(connectionStringSettings.ConnectionString);
                break;

            case "mysql.data.mysqlclient":
                database = new MySqlDataAccess(connectionStringSettings.ConnectionString);
                break;
                ////case "system.data.oleDb":
                ////    database = new OledbDataAccess(connectionStringSettings.ConnectionString);
                ////    break;
                //case "MySql.Data.MySqlClient":
                //    database = new OdbcDataAccess(connectionStringSettings.ConnectionString);
                //    break;
            }

            return(database);
        }