dotConnect for Oracle Documentation
Devart.Common Namespace / TransactionStateChangeEventArgs Class
Members Example

In This Topic
    TransactionStateChangeEventArgs Class
    In This Topic
    Syntax
    'Declaration
     
    Public MustInherit Class TransactionStateChangeEventArgs 
       Inherits System.EventArgs
    public abstract class TransactionStateChangeEventArgs : System.EventArgs 
    Example
    This sample demonstrates how the common base TransactionStateChangeEventArgs class for TransactionStateChanged and TransactionStateChanging envent arguments allows using more general code.
    OracleConnection connection = new OracleConnection(
        "User Id=Scott;Password=tiger;Data Source=Ora;");
       connection.TransactionStateChanged += new TransactionStateChangedEventHandler(connection_TransactionStateChange);
       connection.TransactionStateChanging += new TransactionStateChangingEventHandler(connection_TransactionStateChange);
       connection.Open();
       // ...
    OracleTransaction transaction = connection.BeginTransaction();
       // ...
       transaction.Commit();
       // ...
    
    void connection_TransactionStateChange(object sender, TransactionStateChangeEventArgs e) {
    
            // common actions that must be done before and after the transaction state change
            // ...
    
            if (e is TransactionStateChangingEventArgs) {
                    // actions before the transaction state change
                    // ...
            }
            else { // e is TransactionStateChangedEventArgs
                    // actions after the transaction state change
                    // ...
            }
    }
    Dim connection As New OracleConnection( _
        "User Id=Scott;Password=tiger;Data Source=Ora;")
    AddHandler connection.TransactionStateChanged, New TransactionStateChangedEventHandler(AddressOf &_ Me.connection_TransactionStateChange)
            AddHandler connection.TransactionStateChanging, New TransactionStateChangingEventHandler(AddressOf &_ Me.connection_TransactionStateChange)
            connection.Open()
            ' ...
            Dim Transaction As OracleTransaction
            Transaction = connection.BeginTransaction()
            ' ...
            Transaction.Commit()
            ' ...
    
            Private Sub connection_TransactionStateChange(ByVal sender As Object, ByVal e As TransactionStateChangeEventArgs)
            ' common actions that must be done before and after the transaction state change
            '...
            If TypeOf e Is TransactionStateChangingEventArgs Then
                    ' actions before the transaction state change
                    ' ...
            Else ' e is TransactionStateChangedEventArgs
                    ' actions after the transaction state change
                    ' ...
            End If
    End Sub
    Inheritance Hierarchy

    System.Object
       System.EventArgs
          Devart.Common.TransactionStateChangeEventArgs
             Devart.Common.TransactionStateChangedEventArgs
             Devart.Common.TransactionStateChangingEventArgs

    See Also