/// <summary>
/// Same as <see cref="Connect(string, string)"/>(string, string) only this uses an enumeration.
/// </summary>
/// <param name="driver">The driver enumeration for you DBMS system</param>
/// <param name="pluginName">The name of the plugin</param>
/// <param name="connectionString">A valid connection string for you DBMS</param>
/// <returns></returns>
public bool Connect(dbDriver driver, string pluginName, string connectionString)
{
Reset();
string dbName;
int index;
_connectionString = connectionString.Replace("\"", "");
_driver = driver;
#region not fully implemented yet
/*
* InternalDriver drv = InternalDriver.Get(settings.DbDriver);
* if (drv != null)
* {
* this._driverString = drv.DriverId;
* this.StripTrailingNulls = drv.StripTrailingNulls;
* this.requiredDatabaseName = drv.RequiredDatabaseName;
*
* IDbConnection con = null;
* try
* {
* ClassFactory = drv.CreateBuildInClass();
* if (ClassFactory != null)
* con = ClassFactory.CreateConnection();
* else
* {
* IMyMetaPlugin plugin = drv.CreateMyMetaPluginClass();
* if (plugin != null)
* {
* MyMetaPluginContext pluginContext = new MyMetaPluginContext(drv.DriverId, this._connectionString);
* plugin.Initialize(pluginContext);
* con = plugin.NewConnection;
* }
* }
* if (con != null)
* {
* con.ConnectionString = this._connectionString;
* // cn.Open();
* }
* this._defaultDatabase = drv.GetDataBaseName(cn);
* }
* catch(Exception Ex)
* {
* throw Ex;
* } finally {
* if (con != null)
* cn.Close();
* }
* }
* else
* {
* // Error
* }
*/
#endregion not fully implemented yet
switch (_driver)
{
case dbDriver.SQL:
ConnectUsingOleDb(_driver, _connectionString);
_driverString = MyMetaDrivers.SQL;
StripTrailingNulls = false;
requiredDatabaseName = true;
ClassFactory = new ClassFactory();
break;
case dbDriver.Oracle:
ConnectUsingOleDb(_driver, _connectionString);
_driverString = MyMetaDrivers.Oracle;
StripTrailingNulls = false;
requiredDatabaseName = true;
ClassFactory = new Oracle.ClassFactory();
break;
case dbDriver.Access:
ConnectUsingOleDb(_driver, _connectionString);
_driverString = MyMetaDrivers.Access;
StripTrailingNulls = false;
requiredDatabaseName = false;
ClassFactory = new Access.ClassFactory();
break;
case dbDriver.MySql:
ConnectUsingOleDb(_driver, _connectionString);
_driverString = MyMetaDrivers.MySql;
StripTrailingNulls = true;
requiredDatabaseName = true;
ClassFactory = new MySql.ClassFactory();
break;
case dbDriver.MySql2:
using (var mysqlconn = new MySqlConnection(_connectionString))
{
mysqlconn.Close();
mysqlconn.Open();
_defaultDatabase = mysqlconn.Database;
}
_driverString = MyMetaDrivers.MySql2;
StripTrailingNulls = true;
requiredDatabaseName = true;
ClassFactory = new MySql5.ClassFactory();
break;
case dbDriver.DB2:
ConnectUsingOleDb(_driver, _connectionString);
_driverString = MyMetaDrivers.DB2;
StripTrailingNulls = false;
requiredDatabaseName = false;
ClassFactory = new DB2.ClassFactory();
break;
case dbDriver.ISeries:
ConnectUsingOleDb(_driver, _connectionString);
_driverString = MyMetaDrivers.ISeries;
StripTrailingNulls = false;
requiredDatabaseName = false;
ClassFactory = new ISeries.ClassFactory();
break;
case dbDriver.Pervasive:
ConnectUsingOleDb(_driver, _connectionString);
_driverString = MyMetaDrivers.Pervasive;
StripTrailingNulls = false;
requiredDatabaseName = false;
ClassFactory = new Pervasive.ClassFactory();
break;
case dbDriver.PostgreSQL:
using (var cn = new NpgsqlConnection(_connectionString))
{
cn.Open();
_defaultDatabase = cn.Database;
}
_driverString = MyMetaDrivers.PostgreSQL;
StripTrailingNulls = false;
requiredDatabaseName = false;
ClassFactory = new PostgreSQL.ClassFactory();
break;
case dbDriver.PostgreSQL8:
using (var cn8 = new NpgsqlConnection(_connectionString))
{
cn8.Open();
_defaultDatabase = cn8.Database;
}
_driverString = MyMetaDrivers.PostgreSQL8;
StripTrailingNulls = false;
requiredDatabaseName = false;
ClassFactory = new PostgreSQL8.ClassFactory();
break;
case dbDriver.Firebird:
using (var cn1 = new FbConnection(_connectionString))
{
cn1.Open();
dbName = cn1.Database;
}
try
{
index = dbName.LastIndexOfAny(new[] { '\\' });
if (index >= 0)
{
_defaultDatabase = dbName.Substring(index + 1);
}
}
catch {}
_driverString = MyMetaDrivers.Firebird;
StripTrailingNulls = false;
requiredDatabaseName = false;
ClassFactory = new Firebird.ClassFactory();
break;
case dbDriver.Interbase:
using (var cn2 = new FbConnection(_connectionString))
{
cn2.Open();
_defaultDatabase = cn2.Database;
}
_driverString = MyMetaDrivers.Interbase;
StripTrailingNulls = false;
requiredDatabaseName = false;
ClassFactory = new Firebird.ClassFactory();
break;
case dbDriver.SQLite:
using (var sqliteConn = new SQLiteConnection(_connectionString))
{
sqliteConn.Open();
dbName = sqliteConn.Database;
}
_driverString = MyMetaDrivers.SQLite;
StripTrailingNulls = false;
requiredDatabaseName = false;
ClassFactory = new SQLite.ClassFactory();
break;
#if !IGNORE_VISTA
case dbDriver.VistaDB:
try
{
var mh = new MetaHelper();
dbName = mh.LoadDatabases(_connectionString);
if (dbName == "")
{
return(false);
}
_defaultDatabase = dbName;
_driverString = MyMetaDrivers.VistaDB;
StripTrailingNulls = false;
requiredDatabaseName = false;
ClassFactory = new VistaDB.ClassFactory();
}
catch
{
throw new Exception("Invalid VistaDB connection or VistaDB not installed");
}
break;
#endif
case dbDriver.Advantage:
ConnectUsingOleDb(_driver, _connectionString);
_driverString = MyMetaDrivers.Advantage;
StripTrailingNulls = false;
requiredDatabaseName = false;
ClassFactory = new Advantage.ClassFactory();
string[] s = _defaultDatabase.Split('.');
_defaultDatabase = s[0];
break;
case dbDriver.Plugin:
break;
case dbDriver.None:
_driverString = MyMetaDrivers.None;
break;
}
_isConnected = true;
return(true);
}