//methods
/// <summary>
/// Routine to return a list of table names for the database pointed to by the current connection string.
/// </summary>
/// <returns>Object containing list of table definitions.</returns>
public PFList <PFTableDef> GetTableList(string tablesToIncludePattern, string tablesToExcludePattern)
{
PFList <PFTableDef> tableList = null;
PFDatabase db = null;
string[] includePatterns = { string.Empty };
string[] excludePatterns = { string.Empty };
if (this.DbPlatform == DatabasePlatform.Unknown)
{
return(null);
}
if (this.ConnectionString.Length == 0)
{
return(null);
}
try
{
includePatterns[0] = tablesToIncludePattern.Trim();
excludePatterns[0] = tablesToExcludePattern.Trim();
db = new PFDatabase(this.DbPlatform, this.DbDllPath, this.DbNamespace + "." + this.DbClassName);
db.ConnectionString = this.ConnectionString;
db.OpenConnection();
tableList = db.GetTableList(includePatterns, excludePatterns);
db.CloseConnection();
}
catch (System.Exception ex)
{
_msg.Length = 0;
_msg.Append("Attempt to retrieve list of table names failed: ");
_msg.Append(AppGlobals.AppMessages.FormatErrorMessage(ex));
throw new System.Exception(_msg.ToString());
}
finally
{
if (db != null)
{
if (db.IsConnected)
{
db.CloseConnection();
}
db = null;
}
}
return(tableList);
}