Gemstone Data Library
Ado
Executes the SQL statement using Connection, and returns the first DataTable
of result set, if the result set contains at least one table, as an asynchronous enumerable.
Definition
Namespace: Gemstone.Data
Assembly: Gemstone.Data (in Gemstone.Data.dll) Version: 1.0.138 -- Release Build+f7ceb3e02ea3c92b27e86b99ae16cee337a20b9e
An asynchronous enumerable of DataRow objects.
Assembly: Gemstone.Data (in Gemstone.Data.dll) Version: 1.0.138 -- Release Build+f7ceb3e02ea3c92b27e86b99ae16cee337a20b9e
C#
public IAsyncEnumerable<DataRow> RetrieveDataAsAsyncEnumerable(
string sqlFormat,
CancellationToken cancellationToken,
params Object?[] parameters
)VB
Public Function RetrieveDataAsAsyncEnumerable (
sqlFormat As String,
cancellationToken As CancellationToken,
ParamArray parameters As Object()
) As IAsyncEnumerable(Of DataRow)C++
public:
IAsyncEnumerable<DataRow^>^ RetrieveDataAsAsyncEnumerable(
String^ sqlFormat,
CancellationToken cancellationToken,
... array<Object^>^ parameters
)JavaScript
function RetrieveDataAsAsyncEnumerable(sqlFormat, cancellationToken, ... parameters);Parameters
- 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
IAsyncEnumerableDataRowAn asynchronous enumerable of DataRow objects.
Remarks
This method first reads data into memory as a DataTable then enumerates over its rows.
If the DataTable schema can be derived in advance, use the
RetrieveDataAsAsyncEnumerable(DataTable, String, CancellationToken, Object)
overload instead that takes the schema and uses a DbDataReader to enumerate over the
rows directly without caching into memory first as an optimization.