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