The retrieval of the rows of a SetPageSize(Int32) or per-statement with SetPageSize(Int32). Though new pages are automatically and transparently fetched when needed, it is possible to force the retrieval of the next page early through FetchMoreResults and FetchMoreResultsAsync.is generally paged (a first page of result is fetched and the next one is only fetched once all the results of the first page have been consumed). The size of the pages can be configured either globally through
The RowSet dequeues Row items while iterated. After a full enumeration of this instance, following enumerations will be empty, as all rows have been dequeued.
public class RowSet : IEnumerable<Row>, IEnumerable, IDisposable
Thetype exposes the following members.
Gets or sets the columns in the RowSet
Gets the execution info of the query
Whether all results from this result set has been fetched from the database.
Gets or sets the paging state of the query for the RowSet. When set it states that there are more pages.
|Dispose|| Obsolete. |
For backward compatibility only
Forces the fetching the next page of results for this.
Asynchronously retrieves the next page of results for this.
The Task will be completed once the internal queue is filled with the new Row instances.
The number of rows available in this row set that can be retrieved without blocking to fetch.
Returns an enumerator that iterates through the collection.
For backward compatibility: It is possible to iterate using the RowSet as it is enumerable.
Obsolete: Note that it will be removed in future versions
Returns whether this ResultSet has more results. It has side-effects, if the internal queue has been consumed it will page for more results.