RelationalSyncProvider::CreateEnumerationTransaction Method

Creates a read-committed transaction over which to enumerate changes from the database.

Namespace:  Microsoft.Synchronization.Data
Assembly:  Microsoft.Synchronization.Data (in Microsoft.Synchronization.Data.dll)

protected:
virtual IDbTransaction^ CreateEnumerationTransaction()

Return Value

Type: System.Data::IDbTransaction
The transaction used to enumerate changes from the database.

The following code example overrides this method and sets an option that enables snapshot behavior in the Oracle database.

protected override IDbTransaction CreateEnumerationTransaction()
        {
            OracleTransaction trans = (OracleTransaction)this.Connection.BeginTransaction();
            new OracleCommand("set transaction read only", (OracleConnection)this.Connection, trans).ExecuteNonQuery();
            return trans;        
        }


Protected Overloads Overrides Function CreateEnumerationTransaction() As IDbTransaction
    Dim trans As OracleTransaction = DirectCast(Me.Connection.BeginTransaction(), OracleTransaction)
    New OracleCommand("set transaction read only", DirectCast(Me.Connection, OracleConnection), trans).ExecuteNonQuery() 
    Return trans
End Function


Show: