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 2.0 API Reference » ULConnection class

ULConnection class Next Page

ULConnection members

Public constructors
Member nameDescription

ULConnection constructors

Initializes a new instance of the ULConnection class.

Public fields
Member nameDescription


UL Ext.: A database ID constant indicating that the ULConnection.DatabaseID has not been set. This field is constant and read-only.

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.

DataSource 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.

DatabaseManager property

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

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.

ServerVersion property

This feature is not supported by UltraLite.NET.

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 methods

Starts a database transaction.

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.

ChangePassword method

Changes the password for the user indicated in the connection string to the supplied new password.

Close method

Closes the database connection.

CountUploadRows methods

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.

[external link] EnlistTransaction (inherited from DbConnection)

ExecuteTable methods

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

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).

GetSchema methods

Returns schema information for the data source of this [external link] DbConnection.

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 methods

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

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.

See also