public static bool TryConnection(string ConxString, DbsWeLove type, string provider, string DBFileName)
{
DbProviderFactory fact = DbProviderFactories.GetFactory(provider);
DbConnection conn = fact.CreateConnection();
if (conn != null)
{
//Now, change persistence object for new DB.
pest.cfg.MyDBConnectionString = ConxString;
pest.cfg.MyProviderName = provider;
conn.Close();
return(true);
}
return(false);
}
public static bool SwitchDB(string dbfile)
{
DbsWeLove newDB = DbsWeLove.SQLite;
string provider = String.Empty;
switch (Path.GetExtension(dbfile))
{
case ".sqlite":
newDB = DbsWeLove.SQLite;
provider = "System.Data.SQLite";
break;
//case ".sdf":
// newDB = DbsWeLove.SQLServerClient;
// provider = "System.Data.SqlClient";
// break;
//case ".sqlce":
// newDB = DbsWeLove.SQLCE4;
// break;
//case ".mdb":
// newDB = DbsWeLove.MDACJet;
// break;
//todo: Figure out other db types. Only do SQLite and SQL to begin with
//case "SYSTEM.DATA.OLEDB": // dev note: unsure about this as a default
//case "MICROSOFT.ACE.OLEDB.12.0":
// k = DbsWeLove.OleDB64;
// break;
//case "MSDAORA":
// k = DbsWeLove.Oracle;
// break;
//case "SYSTEM.DATA.SQLSERVERCE.3.5":
// k = DbsWeLove.SQLCE3_5;
// break;
default:
return(false);
}
//Try to build new connection string and connect.
DbConnectionStringBuilder csb = new DbConnectionStringBuilder();
csb["Data Source"] = dbfile;
csb["Version"] = "3";
csb["New"] = "False";
csb["Compress"] = "True";
csb["foreign keys"] = "true";
return(TryConnection(csb.ConnectionString, newDB, provider, dbfile));
}
static DbsWeLove ConvertProviderToEnum(string p)
{
DbsWeLove k = DbsWeLove.SQLite;;
switch (p.ToUpper())
{
case "SYSTEM.DATA.SQLITE":
k = DbsWeLove.SQLite;
break;
case "SYSTEM.DATA.SQLCLIENT":
k = DbsWeLove.SQLServerClient;
break;
case "SYSTEM.DATA.SQLSERVERCE.4.0":
k = DbsWeLove.SQLCE4;
break;
case "MICROSOFT.JET.OLEDB.4.0":
k = DbsWeLove.MDACJet;
break;
case "SYSTEM.DATA.OLEDB": // dev note: unsure about this as a default
case "MICROSOFT.ACE.OLEDB.12.0":
k = DbsWeLove.OleDB64;
break;
case "MSDAORA":
k = DbsWeLove.Oracle;
break;
case "SYSTEM.DATA.SQLSERVERCE.3.5":
k = DbsWeLove.SQLCE3_5;
break;
default:
k = DbsWeLove.SQLite;
break;
}
return(k);
}
public static string GetProviderStringFromEnum(DbsWeLove type)
{
string provider = String.Empty;
switch (type)
{
case DbsWeLove.SQLite:
provider = "System.Data.SQLite";
break;
case DbsWeLove.SQLServerClient:
provider = "System.Data.SqlClient";
break;
case DbsWeLove.SQLCE4:
provider = "System.Data.SqlServerCe.4.0";
break;
case DbsWeLove.MDACJet:
provider = "System.Data.OleDb";
break;
}
return(provider);
}
public static string GetProviderStringFromEnum (DbsWeLove type)
{
string provider = String.Empty;
switch (type)
{
case DbsWeLove.SQLite:
provider = "System.Data.SQLite";
break;
case DbsWeLove.SQLServerClient:
provider = "System.Data.SqlClient";
break;
case DbsWeLove.SQLCE4:
provider = "System.Data.SqlServerCe.4.0";
break;
case DbsWeLove.MDACJet:
provider = "System.Data.OleDb";
break;
}
return provider;
}
public static bool TryConnection(string ConxString, DbsWeLove type, string provider, string DBFileName)
{
DbProviderFactory fact = DbProviderFactories.GetFactory(provider);
DbConnection conn = fact.CreateConnection();
if (conn != null)
{
//Now, change persistence object for new DB.
pest.cfg.MyDBConnectionString = ConxString;
pest.cfg.MyProviderName = provider;
conn.Close();
return true;
}
return false;
}
