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