protected virtual void LoadTablesAndViews()
{
OpenConnection();
try
{
var listTables = new List <ITableInfo>();
var listViews = new List <IViewInfo>();
var ds = GetTableViewSchema(Connection);
foreach (DBStructure.INFORMATION_SCHEMA_TABLESRow row in ds.INFORMATION_SCHEMA_TABLES)
{
if (row["TABLE_TYPE"].ToString() != "VIEW")
{
listTables.Add(CreateTableInfo(row));
}
else
{
listViews.Add(CreateViewInfo(row));
}
}
Tables = new DataBaseObjectCollection <ITableInfo>(listTables);
Views = new DataBaseObjectCollection <IViewInfo>(listViews);
}
finally
{
CloseConnection();
}
}
public void LoadProcedures()
{
OpenConnection();
try
{
var ds = GetProcedureSchema(Connection);
if (ds != null)
{
var list = new List <IStoredProcedureInfo>();
foreach (DBStructure.INFORMATION_SCHEMA_ROUTINESRow dr in ds.INFORMATION_SCHEMA_ROUTINES.Rows)
{
if (dr.ROUTINE_TYPE.Equals("PROCEDURE", StringComparison.CurrentCultureIgnoreCase))
{
list.Add(CreateProcedureInfo(dr));
}
}
Procedures = new DataBaseObjectCollection <IStoredProcedureInfo>(list);
}
}
finally
{
CloseConnection();
}
LoadDescriptions();
}
