Gemstone Data Library
Show/Hide TOC

# AdoDataConnectionRetrieveDataAsAsyncEnumerable(DataTable, String, CancellationToken, Object) Method

Executes the SQL statement using Connection using a DbDataReader and returns data rows based on the provided schema as an asynchronous enumerable.

## Definition

Namespace: Gemstone.Data
Assembly: Gemstone.Data (in Gemstone.Data.dll) Version: 1.0.153 -- Release Build+42f3d0bf0373d5bc86f6d691e637d32f2b3150d2
C#
View Source Request Example

    public IAsyncEnumerable<DataRow> RetrieveDataAsAsyncEnumerable(
    	DataTable schema,
    	string sqlFormat,
    	CancellationToken cancellationToken,
    	params Object?[] parameters
    )

VB
View Source Request Example

    Public Function RetrieveDataAsAsyncEnumerable (
    	schema As DataTable,
    	sqlFormat As String,
    	cancellationToken As CancellationToken,
    	ParamArray parameters As Object()
    ) As IAsyncEnumerable(Of DataRow)

C++
View Source Request Example

    public:
    IAsyncEnumerable<DataRow^>^ RetrieveDataAsAsyncEnumerable(
    	DataTable^ schema,
    	String^ sqlFormat,
    	CancellationToken cancellationToken,
    	... array<Object^>^ parameters
    )

JavaScript
View Source Request Example

    function RetrieveDataAsAsyncEnumerable(schema, sqlFormat, cancellationToken, ... parameters);

#### Parameters

schema DataTable
  DataTable that defines the schema for the data rows.
sqlFormat String
  Format string for the SQL statement to be executed.
cancellationToken CancellationToken
  Propagates notification that operations should be canceled.
parameters Object
  The parameter values to be used to fill in DbParameter parameters.

#### Return Value

IAsyncEnumerable DataRow
An asynchronous enumerable of DataRow objects.

## Remarks

If provided schema does not match the schema of the result set based on sqlFormat, the results may be unpredictable or method call may fail.

## See Also

#### Reference

AdoDataConnection Class
RetrieveDataAsAsyncEnumerable Overload
Gemstone.Data Namespace