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; }