Gemstone Data Library
Data
Executes the SQL statement using DbConnection, and returns the first DataTable
of result set, if the result set contains multiple tables.
Definition
Namespace: Gemstone.Data.DataExtensions
Assembly: Gemstone.Data (in Gemstone.Data.dll) Version: 1.0.169 -- Release Build+adcc694938ddb0c37a2b1414eab017f00bb57688
A DataTable object.
Assembly: Gemstone.Data (in Gemstone.Data.dll) Version: 1.0.169 -- Release Build+adcc694938ddb0c37a2b1414eab017f00bb57688
C#
public static Task<DataTable> RetrieveDataAsync(
this DbConnection connection,
int timeout,
string sql,
CancellationToken cancellationToken,
params Object?[] parameters
)VB
<ExtensionAttribute>
Public Shared Function RetrieveDataAsync (
connection As DbConnection,
timeout As Integer,
sql As String,
cancellationToken As CancellationToken,
ParamArray parameters As Object()
) As Task(Of DataTable)C++
public:
[ExtensionAttribute]
static Task<DataTable^>^ RetrieveDataAsync(
DbConnection^ connection,
int timeout,
String^ sql,
CancellationToken cancellationToken,
... array<Object^>^ parameters
)JavaScript
Gemstone.Data.DataExtensions.DataExtensions.RetrieveDataAsync = function(connection, timeout, sql, cancellationToken, ... parameters);Parameters
- connection DbConnection
- The DbConnection to use for executing the SQL statement.
- timeout Int32
- The time in seconds to wait for the SQL statement to execute.
- sql String
- 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 identified by '@' prefix in sql expression.
Return Value
TaskDataTableA DataTable object.