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

SQL Anywhere 11.0.1 (Français) » UltraLite - .NET Programming » UltraLite .NET 2.0 API reference » ULConnection class » BeginTransaction methods

 

BeginTransaction(IsolationLevel) 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.

Syntax
Visual Basic
Public Function BeginTransaction( _
   ByVal isolationLevel As IsolationLevel _
) As ULTransaction
C#
public ULTransaction BeginTransaction(
   IsolationLevel isolationLevel
);
Parameters
  • isolationLevel   The required isolation level for the transaction. UltraLite.NET only supports System.Data.IsolationLevel.ReadUncommitted and ReadCommitted.

Return value

A ULTransaction object representing the new transaction.

Remarks

To associate a command with a transaction object, use the ULCommand.Transaction property. The current transaction is automatically associated to commands created by ULConnection.CreateCommand.

By default, the connection does not use transactions and all commands are automatically committed as they are executed. Once the current transaction is committed or rolled back, the connection reverts to auto commit mode and the previous isolation level until the next call to BeginTransaction.

UltraLite's definition of each isolation level is slightly different than ADO.NET's documentation of IsolationLevel. For more information, see UltraLite isolation levels.

This is the strongly-typed version of System.Data.IDbConnection.BeginTransaction(System.Data.IsolationLevel) and System.Data.Common.DbConnection.BeginTransaction(System.Data.IsolationLevel).

See also