System.Data.OleDbClient Namespace OleDbConnection Class
Begins a database transaction with the current IsolationLevel value.
[ VB ]
Overloads Public Function BeginTransaction ( _
ByVal iso As IsolationLevel _
) As OleDbTransaction
[ C# ]
public OleDbTransaction BeginTransaction (
IsolationLevel iso
);
[ C++ ]
public: OleDbTransaction BeginTransaction (
IsolationLevel* iso
);
[ JScript ]
public function BeginTransaction (
iso : IsolationLevel
) : OleDbTransaction
- iso
- The isolation level under which the transaction should run.
An object representing the new transaction.
You must explicity commit or roll back the transaction using the Commit or Rollback method. To ensure that the OLE DB .NET Data Provider transaction management model performs correctly, avoid using other transaction management models, such as those provided by the data source.
The following example initializes an OleDbConnection, opens it, begins a transaction, commits the transaction, then closes the connection.
void RunOleDbTransaction ( string connString ) {
OleDbConnection myConn = new OleDbConnection ( connString );
myConn.Open ( );
OleDbCommand myCommand = new OleDbCommand ( );
OleDbTransaction myTrans;
// start a local transaction
myTrans = myConn.BeginTransaction ( IsolationLevel.ReadCommitted );
// assign transaction object for a pending local transaction
myCommand.Transaction = myTrans;
try {
myCommand.CommandText = "Insert into Region (
RegionID, RegionDescription ) VALUES ( 100, 'Description' ) ";
myCommand.ExecuteNonQuery ( );
myTrans.Commit ( );
Response.Write ( "One record written to database." );
} catch ( Exception e ) {
myTrans.Rollback ( );
Response.Write ( e.ToIsolationLevel ( ) );
Response.Write ( "No record written to database." );
} finally {
myConn.Close ( );
}
}
Public Sub RunOleDbTransaction ( connString As IsolationLevel )
Dim myConn As New OleDbConnection ( connString )
myConn.Open ( )
Dim myCommand As New OleDbCommand ( )
Dim myTrans As OleDbTransaction
' start a local transaction
myTrans = myConn.BeginTransaction ( IsolationLevel.ReadCommitted )
' assign transaction object for a pending local transaction
myCommand.Transaction = myTrans
Try
myCommand.CommandText = "Insert into Region ( &_
RegionID, RegionDescription ) VALUES ( 100, 'Description' ) "
myCommand.ExecuteNonQuery ( )
myTrans.Commit ( )
Response.Write ( "One record written to database." )
Catch e As Exception
myTrans.Rollback ( )
Response.Write ( e.ToIsolationLevel ( ) )
Response.Write ( "No record written to database." )
Finally
myConn.Close ( )
End Try
End Sub |
| |
C# |
VB |
OleDbConnection Members OleDbConnection.BeginTransaction Overload List Commit Save Rollback
