Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » UltraLite - .NET Programming » UltraLite .NET 1.0 API Reference » ULConnection class

ULConnection class Next Page

ULConnection members


Public static fields (shared)
Member nameDescription
INVALID_DATABASE_ID field

UL Ext.: A database ID constant indicating that the ULConnection.DatabaseID has not been set.

Public static properties (shared)
Member nameDescription
DatabaseManager property

UL Ext.: Provides access to the singleton ULDatabaseManager object.

Public constructors
Member nameDescription
ULConnection constructor

Initializes a ULConnection object. The connection must be opened before you can perform any operations against the database.

ULConnection constructor

Initializes a ULConnection object with the specified connection string. The connection must be opened before you can perform any operations against the database.

Public properties
Member nameDescription
ConnectionString property

Specifies the parameters to use for opening a connection to an UltraLite.NET database. The connection string can be supplied using a ULConnectionParms object.

ConnectionTimeout property

This feature is not supported by UltraLite.NET.

Database property

Returns the name of the database to which the connection opens.

DatabaseID property

UL Ext.: Specifies the Database ID value to be used for global autoincrement columns.

GlobalAutoIncrementUsage property

UL Ext.: Returns the percentage of available global autoincrement values that have been used.

LastIdentity property

UL Ext.: Returns the most recent identity value used.

Schema property

UL Ext.: Provides access to the schema of the current database associated with this connection.

State property

Returns the current state of the connection.

SyncParms property

UL Ext.: Specifies the synchronization settings for this connection.

SyncResult property

UL Ext.: Returns the results of the last synchronization for this connection.

Public methods
Member nameDescription
BeginTransaction method

Returns a transaction object. Commands associated with a transaction object are executed as a single transaction. The transaction is terminated with ULTransaction.Commit or ULTransaction.Rollback.

BeginTransaction method

Returns a transaction object with the specified isolation level. Commands associated with a transaction object are executed as a single transaction. The transaction is terminated with ULTransaction.Commit or ULTransaction.Rollback.

ChangeDatabase method

Changes the current database for an open ULConnection.

ChangeEncryptionKey method

UL Ext.: Changes the database's encryption key to the specified new key.

Close method

Closes the database connection.

CountUploadRows method

UL Ext.: Returns the number of rows that need to be uploaded when the next synchronization takes place.

CountUploadRows method

UL Ext.: Returns the number of rows that need to be uploaded when the next synchronization takes place.

CreateCommand method

Creates and initializes a ULCommand object associated with this connection and its current transaction. You can use the properties of the ULCommand to control its behavior.

ExecuteTable method

UL Ext.: Retrieves in a ULTable a database table for direct manipulation. The table is opened (sorted) using the table's primary key.

ExecuteTable method

UL Ext.: Retrieves in a ULTable a database table for direct manipulation. The table is opened (sorted) using the specified index.

ExecuteTable method

UL Ext.: Retrieves, with the specified command behavior, a database table for direct manipulation. The table is opened (sorted) using the specified index.

GetLastDownloadTime method

UL Ext.: Returns the time of the most recent download of the specified publication.

GetNewUUID method

UL Ext.: Generates a new UUID (System.Guid).

GrantConnectTo method

UL Ext.: Grants access to an UltraLite database for a user ID with a specified password.

Open method

Opens a connection to a database using the previously-specified connection string.

ResetLastDownloadTime method

UL Ext.: Resets the time of the most recent download.

RevokeConnectFrom method

UL Ext.: Revokes access to an UltraLite database from the specified user ID.

RollbackPartialDownload method

UL Ext.: Rolls back outstanding changes to the database from a partial download.

StartSynchronizationDelete method

UL Ext.: Marks all subsequent deletes made by this connection for synchronization.

StopSynchronizationDelete method

UL Ext.: Prevents delete operations from being synchronized.

Synchronize method

UL Ext.: Synchronize the database using the current ULConnection.SyncParms.

Synchronize method

UL Ext.: Synchronize the database using the current ULConnection.SyncParms with progress events posted to the specified listener.

Public events
Member nameDescription
InfoMessage event

Occurs when UltraLite.NET sends a warning or an informational message on this connection.

StateChange event

Occurs when this connection changes state.