AceQL HTTP C# Client SDK v2.0

AceQL.Client.Api Namespace

The AceQL.Client.Api namespace allows mobile and desktop application developers to access remote SQL databases and/or SQL databases in the cloud by simply including standard SQL calls in their code. The syntax is identical to the Microsoft SQL Server C# API.

Classes


  Class Description
Public class AceQLCommand
Represents a SQL statement to execute against a remote SQL database.
Public class AceQLConnection
Class AceQLConnection. Allows to create a database connection to the remote server.
Public class AceQLCredential
AceQLCredential provides a more secure way than using a connection string to specify the username or password for a login attempt.

Note that this version does not encrypt the password. This could and should be done in a future version.

Public class AceQLDataReader
Class AceQLDataReader. Provides a way of reading a forward-only stream of rows from a remote database transferred in a local file.

Note that all data of the stream are already downloaded when AceQLDataReader is created.

Public class AceQLException
Class AceQLException. All client and server side exceptions raised are wrapped in an AceQLException.
Public class AceQLParameter
Represents a parameter to an AceQLCommand.
Public class AceQLParameterCollection
Represents a collection of parameters associated with an AceQLCommand and their respective mappings to columns.
Public class AceQLProgressIndicator
AceQLProgressIndicator Class. Allows to get the percentage progress between 0 and 100 for Blob/Clob upload.
Public class AceQLTransaction
Class AceQLTransaction. Allows to define a Transaction in order to execute remote commit or rollback.

Enumerations


  Enumeration Description
Public enumeration AceQLNullType
Specifies the SQL type to pass to the server when setting a value to NULL with AceQLParameter.
Public enumeration IsolationLevel
Specifies the transaction locking behavior for the remote connection.