/// <summary> /// Parse Connection String /// </summary> /// <param name="pConnectionString">Connection String</param> /// <returns>string</returns> public static string ParseConnectionString(string pConnectionString) { string result = null; string Test = pConnectionString.Trim(new char[] { '\'' }); DBReadExecute.ProjectFileName = ""; if (Test.ToLowerInvariant().EndsWith(".prj")) { Project P = new Project(Test); Test = P.CollectedDataConnectionString; result = Test; DBReadExecute.DataSource = DbDriverFactoryCreator.GetDbDriverFactory(P.CollectedDataDriver); DBReadExecute.ProjectFileName = pConnectionString.Trim(new char[] { '\'' }); } else { DataSets.Config.DataDriverDataTable dataDrivers = Configuration.GetNewInstance().DataDrivers; foreach (DataSets.Config.DataDriverRow dataDriver in dataDrivers) { IDbDriverFactory dbFactory = DbDriverFactoryCreator.GetDbDriverFactory(dataDriver.Type); if (dbFactory.CanClaimConnectionString(Test)) { DBReadExecute.DataSource = dbFactory; result = dbFactory.ConvertFileStringToConnectionString(Test); break; } } } return(result); }
/// <summary> /// Check Database Table Existance /// </summary> /// <param name="pFileString">File String</param> /// <param name="pTableName">Table name</param> /// <returns>bool</returns> public static bool CheckDatabaseTableExistance(string pFileString, string pTableName, bool pIsConnectionString = false) { DataSets.Config.DataDriverDataTable dataDrivers = Configuration.GetNewInstance().DataDrivers; IDbDriverFactory dbFactory = null; foreach (DataSets.Config.DataDriverRow dataDriver in dataDrivers) { dbFactory = DbDriverFactoryCreator.GetDbDriverFactory(dataDriver.Type); if (dbFactory.CanClaimConnectionString(pFileString)) { break; } } IDbDriver dbDriver = DBReadExecute.GetDataDriver(pFileString, pIsConnectionString); return(dbDriver.CheckDatabaseTableExistance(pFileString, pTableName, pIsConnectionString)); }