/// <summary> /// Execute a SELECT query. /// </summary> /// <param name="tableName">The table from which you wish to SELECT.</param> /// <param name="indexStart">The starting index for retrieval; used for pagination in conjunction with maxResults and orderByClause. orderByClause example: ORDER BY created DESC.</param> /// <param name="maxResults">The maximum number of results to retrieve.</param> /// <param name="returnFields">The fields you wish to have returned. Null returns all.</param> /// <param name="filter">The expression containing the SELECT filter (i.e. WHERE clause data).</param> /// <param name="orderByClause">Specify an ORDER BY clause if desired.</param> /// <returns>A DataTable containing the results.</returns> public DataTable Select(string tableName, int?indexStart, int?maxResults, List <string> returnFields, Expression filter, string orderByClause) { if (String.IsNullOrEmpty(tableName)) { throw new ArgumentNullException(nameof(tableName)); } return(Query(MysqlHelper.SelectQuery(tableName, indexStart, maxResults, returnFields, filter, orderByClause))); }