AceQLCommand Members
The AceQLCommand type exposes the following members.
Constructors
| Name | Description | |
|---|---|---|
|
AceQLCommand()()()() |
Initializes a new instance of the AceQLCommand class.
|
|
|
AceQLCommand(String) |
Initializes a new instance of the AceQLCommand class with the text of the query.
|
|
|
AceQLCommand(String, AceQLConnection) |
Initializes a new instance of the AceQLCommand class with the text of the query
and a AceQLConnection.
|
|
|
AceQLCommand(AceQLConnection) |
Initializes a new instance of the AceQLCommand class.
|
|
|
AceQLCommand(String, AceQLConnection, AceQLTransaction) |
Initializes a new instance of the AceQLCommand class with the text of the query and a
AceQLConnection, and the AceQLTransaction.
|
Methods
| Name | Description | |
|---|---|---|
|
|
AddBatch |
Adds a set of parameters to this batch of commands.
|
|
|
ClearBatch |
Empties this current batch of commands.
|
|
|
Dispose()()()() |
Disposes this instance. This call is optional and does nothing because all resources are released after
each other AceQLCommand method call. Class implements [IDisposable] to ease code migration.
|
|
|
ExecuteBatchAsync(CancellationToken) |
Submits a batch of commands to the database for execution and if all commands execute successfully,
returns an array of update counts.
The int elements of the array that is returned are ordered to correspond to the commands in the batch,
which are ordered according to the order in which they were added to the batch.
The cancellation token can be used to can be used to request that the operation
be abandoned before the http request timeout.
|
|
|
ExecuteBatchAsync()()()() |
Submits a batch of commands to the database for execution and if all commands execute successfully,
returns an array of update counts.
The int elements of the array that is returned are ordered to correspond to the commands in the batch,
which are ordered according to the order in which they were added to the batch.
The cancellation token can be used to can be used to request that the operation
be abandoned before the http request timeout.
|
|
|
ExecuteNonQueryAsync(CancellationToken) |
Executes the SQL statement against the connection and returns the number of rows affected.
The cancellation token can be used to can be used to request that the operation be abandoned before the http request timeout.
|
|
|
ExecuteNonQueryAsync()()()() |
Executes the SQL statement against the connection and returns the number of rows affected.
|
|
|
ExecuteReaderAsync(CancellationToken) |
Sends the AceQLCommand.CommandText to the AceQLConnection and builds an AceQLDataReader.
The cancellation token can be used to can be used to request that the operation be abandoned before the http request timeout.
|
|
|
ExecuteReaderAsync()()()() | |
|
|
ExecuteScalar(CancellationToken) |
Executes the query, and returns the first column of the first row in the result set returned by the query.
Additional columns or rows are ignored.
The cancellation token can be used to can be used to request that the operation be abandoned before the http request timeout
|
|
|
ExecuteScalar()()()() |
Executes the query, and returns the first column of the first row in the result set returned by the query.
Additional columns or rows are ignored.
|
|
|
ExecuteServerQueryAsync(String, List<(Of <<'(Object>)>>), CancellationToken) |
Executes a server query by calling a remote AceQL ServerQueryExecutor interface concrete implementation.
|
|
|
ExecuteServerQueryAsync(String, List<(Of <<'(Object>)>>)) |
Executes a server query by calling a remote AceQL ServerQueryExecutor interface concrete implementation.
|
|
|
Prepare |
Creates a prepared version of the command. Optional call.
Note that the remote statement will always be a prepared statement if
the command contains parameters.
|
Properties
| Name | Description | |
|---|---|---|
|
CommandText |
Gets ot set SQL statement to execute against a remote SQL database.
|
|
|
CommandType |
Gets or sets a value indicating how the CommandText property is to be interpreted.
|
|
|
Connection |
Gets or sets the AceQLConnection used by this instance of AceQLCommand.
|
|
|
Parameters |
Gets the AceQLParameterCollection.
|
|
|
Transaction |
Gets or sets the AceQLTransaction used by this instance of AceQLCommand.
|