AceQL HTTP C# Client SDK v2.0

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)
Determines whether the specified object is equal to the current 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
Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection.
(Inherited from Object.)
Public method GetHashCode
Serves as the default hash function.
(Inherited from Object.)
Public method GetType
Gets the Type of the current instance.
(Inherited from Object.)
Protected method MemberwiseClone
Creates a shallow copy of the current Object.
(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
Returns a string that represents the current object.
(Inherited from Object.)

Properties


  Name Description
Public property CommandText
Gets ot set SQL statement to execute against a remote SQL database.
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.