AceQL HTTP C# Client SDK v7.5.2

AceQLConnection Members

The AceQLConnection type exposes the following members.

Constructors


  Name Description
Public method AceQLConnection()()()()
Initializes a new instance of the AceQLConnection class.
Public method AceQLConnection(String)
Initializes a new instance of the AceQLConnection class when given a string that contains the connection string.
Public method AceQLConnection(String, AceQLCredential)
Initializes a new instance of the AceQLConnection class when given a string that contains the connection string and an AceQLCredential object that contains the username and password.

Methods


  Name Description
Public method AddRequestHeader
Adds A request header. The header will be added at each server call.
Public method BeginTransactionAsync(CancellationToken)
Initializes a AceQLTransactionobject. This will put the remote connection in auto commit mode off.

The cancellation token can be used to can be used to request that the operation be abandoned before the http request timeout.

Public method BeginTransactionAsync()()()()
Initializes a AceQLTransactionobject. This will put the remote connection in auto commit mode off.
Public method BeginTransactionAsync(IsolationLevel, CancellationToken)
Initializes a new AceQLTransactionobject with the specified isolation level. This will put the remote connection in auto commit mode off.

The cancellation token can be used to can be used to request that the operation be abandoned before the http request timeout.

Public method BeginTransactionAsync(IsolationLevel)
Initializes a new AceQLTransactionobject with the specified isolation level. This will put the remote connection in auto commit mode off.
Public method CloseAsync
Closes the connection to the remote database. This is the preferred method of closing any open connection.
Public method Dispose()()()()
If connection has not been closed by an explicit call to AceQLConnectionCloseAsync: calls silently AceQLConnectionCloseAsync without reporting any Exception.

As the call is not awaited, execution of the current method continues before the call to is AceQLConnectionCloseAsync completed.

Public method Static member GetAceQLLocalFolder
Gets the path to the local AceQL folder where SQL queries results are stored.
Public method Static member GetClientVersion
Returns the AceQL Client SDK current Version.
Public method GetDatabaseInfoAsync
A shortcut to remote database metadata which returns remote database and remote JDBC Driver main info.
Public method Static member GetDefaultWebProxy
Gets the default web proxy set. Returns null if none was previously set by SetDefaultWebProxy(IWebProxy).
Public method GetProgressIndicator
Returns the progress indicator variable that will store Blob/Clob upload progress between 0 and 100.
Public method GetRemoteDatabaseMetaData
Creates a RemoteDatabaseMetaData in order to query remote database metadata info.
Public method GetServerVersionAsync(CancellationToken)
Returns the remote AceQL HTTP Server Version.

The cancellation token can be used to can be used to request that the operation be abandoned before the http request timeout.

Public method GetServerVersionAsync()()()()
Returns the remote AceQL HTTP Server Version.
Public method LogoutAsync
Closes the session to the remote AceQL server and Close on server all the connections to the database. This is the preferred method of closing any open connection.
Public method OpenAsync()()()()
Opens a connection with the remote database.
Public method OpenAsync(CancellationToken)
Opens a connection with the remote database.

The cancellation token can be used to can be used to request that the operation be abandoned before the http request timeout.

Public method ResetRequestHeaders
Resets the request headers. The previously added headers with AddRequestHeader(String, String) will be suppressed.
Public method Static member SetDefaultWebProxy
Sets the default web proxy to use. Allows to force to use on some environments (Windows, ...) System.Net.WebRequest.GetSystemProxy() instead of [System.Net.WebRequest.DefaultWebProxy].
Public method SetProgressIndicator
Sets the progress indicator variable that will store Blob/Clob upload progress between 0 and 100.

Properties


  Name Description
Public property ConnectionInfo
Gets the connection information.
Public property Credential
Gets or sets the AceQLCredential object for this connection.
Public property RequestRetry
Gets or sets a value indicating whether a failed request will be retried. The retry will be done once, without compression. Defaults to true.