AceQL HTTP C# Client SDK v5.5

AceQLCommand Members

The AceQLCommand type exposes the following members.

Constructors


  Name Description
Public method AceQLCommand()()()()
Initializes a new instance of the AceQLCommand class.
Public method AceQLCommand(String)
Initializes a new instance of the AceQLCommand class with the text of the query.
Public method AceQLCommand(String, AceQLConnection)
Initializes a new instance of the AceQLCommand class with the text of the query and a AceQLConnection.
Public method 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
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 Equals(System.Object) (Inherited from Object.)
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.
Protected method Finalize (Inherited from Object.)
Public method GetHashCode (Inherited from Object.)
Public method GetType (Inherited from Object.)
Protected method MemberwiseClone (Inherited from Object.)
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.
Public method ToString (Inherited from Object.)

Properties


  Name Description
Public property CommandText
Gets ot set SQL statement to execute against a remote SQL database.
Public property CommandType
Gets or sets a value indicating how the CommandText property is to be interpreted.
Public property Connection
Gets or sets the AceQLConnection used by this instance of AceQLCommand.
Public property Parameters
Public property Transaction
Gets or sets the AceQLTransaction used by this instance of AceQLCommand.