Method RetrieveAsync

Namespace

Open.Database.Extensions

Assembly

Open.Database.Extensions.Core.dll

RetrieveAsync(int, params IEnumerable<int>)

Asynchronously iterates all records within the current result set using an IDataReader and returns the desired results.

public ValueTask<QueryResultQueue<object[]>> RetrieveAsync(int n, params IEnumerable<int> others)

Parameters

n int

The first ordinal to include in the request to the reader for each record.

others IEnumerable<int>

The remaining ordinals to request from the reader for each record.

Returns

ValueTask<QueryResultQueue<object[]>>

The QueryResult that contains all the results and the column mappings.

RetrieveAsync(string, params IEnumerable<string>)

Iterates all records within the current result set using an IDataReader and returns the desired results.

public ValueTask<QueryResultQueue<object[]>> RetrieveAsync(string c, params IEnumerable<string> others)

Parameters

c string

The first column name to include in the request to the reader for each record.

others IEnumerable<string>

The remaining column names to request from the reader for each record.

Returns

ValueTask<QueryResultQueue<object[]>>

The QueryResult that contains all the results and the column mappings.

RetrieveAsync()

Asynchronously iterates all records within the first result set using an IDataReader and returns the results.

public ValueTask<QueryResultQueue<object[]>> RetrieveAsync()

Returns

ValueTask<QueryResultQueue<object[]>>

The QueryResult that contains all the results and the column mappings.

RetrieveAsync(IEnumerable<int>)

Asynchronously iterates all records within the current result set using an IDataReader and returns the desired results.

public ValueTask<QueryResultQueue<object[]>> RetrieveAsync(IEnumerable<int> ordinals)

Parameters

ordinals IEnumerable<int>

The ordinals to request from the reader for each record.

Returns

ValueTask<QueryResultQueue<object[]>>

The QueryResult that contains all the results and the column mappings.

RetrieveAsync(IEnumerable<string>, bool)

Iterates all records within the first result set using an IDataReader and returns the desired results as a list of Dictionaries containing only the specified column values.

public ValueTask<QueryResultQueue<object[]>> RetrieveAsync(IEnumerable<string> columnNames, bool normalizeColumnOrder = false)

Parameters

columnNames IEnumerable<string>

The column names to select.

normalizeColumnOrder bool

Orders the results arrays by ordinal.

Returns

ValueTask<QueryResultQueue<object[]>>

The QueryResult that contains all the results and the column mappings.