RelationalSyncProvider::CreateEnumerationTransaction Method
Creates a read-committed transaction over which to enumerate changes from the database.
Assembly: Microsoft.Synchronization.Data (in Microsoft.Synchronization.Data.dll)
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: