public override DataTable select(AbstractEntity entity) { try { DataTable dt = new DataTable(); OracleDataReader rd = null; connection.open(); using (cmd = new OracleCommand(entity.querySelect(), connection.get())) { rd = cmd.ExecuteReader(); dt.Load(rd); } return(dt); } catch (OracleException ex) { throw new CompetitionDogException("Ошибка операции получения данных!"); } finally { connection.close(); } }