AceQL HTTP C# Client SDK v7.5.2

AceQLCommand Methods

The AceQLCommand type exposes the following members.

Methods


  Name Description
Public method AddBatch
Adds a set of parameters to this batch of commands.
Public method ClearBatch
Empties this current batch of commands.
Public method 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.
Public method 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.

Public method 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.

Public method 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.

Public method ExecuteNonQueryAsync()()()()
Executes the SQL statement against the connection and returns the number of rows affected.
Public method 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.

Public method ExecuteReaderAsync()()()()
Sends the AceQLCommand.CommandText to the AceQLConnection and builds an AceQLDataReader.
Public method 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

Public method 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.
Public method ExecuteServerQueryAsync(String, List<(Of <<'(Object>)>>), CancellationToken)
Executes a server query by calling a remote AceQL ServerQueryExecutor interface concrete implementation.
Public method ExecuteServerQueryAsync(String, List<(Of <<'(Object>)>>))
Executes a server query by calling a remote AceQL ServerQueryExecutor interface concrete implementation.
Public method 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.