/// <summary> /// Selects all rows from the Riviera code table. /// </summary> /// <param name="conn">The current connection.</param> /// <returns></returns> public static IEnumerable <RivieraCodeRow> SelectAll(DB_Connector conn) { try { QueryBuilder qB = new QueryBuilder(TABLENAME, conn); qB.AddSelectionColumn(); String query = qB.GetQuery(); var result = conn.SelectView <RivieraCodeRow>(query); return(result); } catch (Exception exc) { throw exc.CreateNamelessException <RivieraException>(ERR_LOAD_RIV_CODES); } }
/// <summary> /// Selects all. /// </summary> /// <param name="conn">The database connection</param> /// <param name="tableName">The table name</param> /// <typeparam name="T">The type of selected row</typeparam> /// <returns>The selected rows</returns> public static IEnumerable <T> SelectAll <T>(string tableName, DB_Connector conn) where T : RivieraMeasureRow { try { QueryBuilder qb = new QueryBuilder(tableName, conn); qb.AddSelectionColumn(); String query = qb.GetQuery(); var result = conn.SelectView <T>(query); return(result); } catch (Exception) { return(new T[0]); } }