public IDbConnection BuildConnection(string driver, string connectionString)
{
IDbConnection conn = null;
switch (driver.ToUpper())
{
case MyMetaDrivers.MySql2:
conn = new MySqlConnection(connectionString);
break;
case MyMetaDrivers.PostgreSQL:
case MyMetaDrivers.PostgreSQL8:
conn = new NpgsqlConnection(connectionString);
break;
case MyMetaDrivers.Firebird:
case MyMetaDrivers.Interbase:
conn = new FbConnection(connectionString);
break;
case MyMetaDrivers.SQLite:
conn = new SQLiteConnection(connectionString);
break;
#if !IGNORE_VISTA
case MyMetaDrivers.VistaDB:
try
{
var mh = new MetaHelper();
conn = mh.GetConnection(connectionString);
}
catch
{
throw new Exception("Invalid VistaDB connection or VistaDB not installed");
}
break;
#endif
default:
break;
}
return(conn);
}
