public override List <ITableShortInfo> GetTableNames(string searchString) { string selectStmt = GetStatementForSelectTableNames(searchString); List <ITableShortInfo> tables = new List <ITableShortInfo>(); InternalSqlServerConnection connection = null; try { connection = new InternalSqlServerConnection(DbContext.ConnectionString); using (InternalSqlServerCommand command = new InternalSqlServerCommand(selectStmt, connection)) { SqlDataReader reader = command.Command.ExecuteReader(CommandBehavior.CloseConnection); while (reader.Read()) { tables.Add(TableShortInfoFactory.CreateInstance(reader.GetString(0), GetRowCount(reader.GetString(0)))); } } } catch (Exception ex) { throw new ADatabaseException("ERROR when getting table names: " + selectStmt, ex); } finally { if (connection != null) { connection.Close(); } } return(tables); }
public override List <ITableShortInfo> GetTableNames(string searchString) { var selectStmt = GetStatementForSelectTableNames(searchString); var tables = new List <ITableShortInfo>(); var cursor = DbContext.PowerPlant.CreateDataCursor(); try { var reader = cursor.ExecuteReader(selectStmt); while (reader.Read()) { tables.Add(TableShortInfoFactory.CreateInstance(reader.GetString(0), GetRowCount(reader.GetString(0)))); } } catch (Exception ex) { throw new ADatabaseException("ERROR with statement in GetTableNames", ex); } finally { cursor.Close(); } return(tables); }