/// <summary>
/// Get Command
/// </summary>
/// <param name="pFileName">File name</param>
/// <param name="pKeyString">Key String</param>
/// <param name="pDataTable">Data Table</param>
/// <returns>DbCommand</returns>
public static System.Data.Common.DbCommand GetCommand(string pFileName, string pKeyString, DataTable pDataTable)
{
System.Data.Common.DbCommand result = null;
string connString = DBReadExecute.ParseConnectionString(pFileName);
if (DataSource != null)
{
IDbDriver driver = DataSource.CreateDatabaseObject(new System.Data.Common.DbConnectionStringBuilder());
driver.ConnectionString = connString;
result = driver.GetCommand(pKeyString, pDataTable);
}
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));
}