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.172 -- Release Build+ae476bbd72ef96dd0921ba95a5ad3a46d4d6115e
An asynchronous enumerable of DataRow objects.
Assembly: Gemstone.Data (in Gemstone.Data.dll) Version: 1.0.172 -- Release Build+ae476bbd72ef96dd0921ba95a5ad3a46d4d6115e
C#
public IAsyncEnumerable<DataRow> RetrieveDataAsAsyncEnumerable(
int timeout,
string sqlFormat,
CancellationToken cancellationToken,
params Object?[] parameters
)VB
Public Function RetrieveDataAsAsyncEnumerable (
timeout As Integer,
sqlFormat As String,
cancellationToken As CancellationToken,
ParamArray parameters As Object()
) As IAsyncEnumerable(Of DataRow)C++
public:
IAsyncEnumerable<DataRow^>^ RetrieveDataAsAsyncEnumerable(
int timeout,
String^ sqlFormat,
CancellationToken cancellationToken,
... array<Object^>^ parameters
)JavaScript
function RetrieveDataAsAsyncEnumerable(timeout, sqlFormat, cancellationToken, ... parameters);Parameters
- timeout Int32
- The time in seconds to wait for the SQL statement to execute.
- 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, Int32, 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.