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)
Syntax
'Declaration
Protected Overridable Function CreateEnumerationTransaction As IDbTransaction
'Usage
Dim returnValue As IDbTransaction
returnValue = Me.CreateEnumerationTransaction()
protected virtual IDbTransaction CreateEnumerationTransaction()
protected:
virtual IDbTransaction^ CreateEnumerationTransaction()
abstract CreateEnumerationTransaction : unit -> IDbTransaction
override CreateEnumerationTransaction : unit -> IDbTransaction
protected function CreateEnumerationTransaction() : IDbTransaction
Return Value
Type: System.Data.IDbTransaction
The transaction used to enumerate changes from the database.
Examples
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