Transaction Processing

Question

Hi... I am doing work in ado.net and define Transaction Processing. How can we use Transaction Processing and define syntax ?

Satyapriya Nayak · Answer

Hi Aaron Transaction Processing in ADO.NET ADO.NET supports transactions through the Transaction object which is created against an open connection. Commands that are executed against the connection while the transaction is pending must be enrolled in the transaction by assigning a reference to the Transaction object to their Transaction property. Commands cannot be executed against the Connection outside the transaction while it is pending. If the transaction is committed all of the commands that form a part of that transaction will be permanently written to the data source. If the transaction is rolled back all of the commands will be discarded at the data source. Creating Transactions The Transaction object is implemented as part of the data provider. There is a version for each of the intrinsic data providers: OleDbTransaction in the System.Data. OleDb namespace and SqlTransaction in the System.Data.SqlClient namespace.The SqlTransaction object is implemented using Microsoft SQL Server transactions—creating a SqlTransaction maps directly to the BeginTransaction statement. The OleDbTransaction is implemented within OLE DB. Transactions are created by calling the BeginTransaction method of the Connection object which returns a reference to a Transaction object. BeginTransaction is overloaded allowing an IsolationLevel. The Connection must be valid and open when BeginTransaction is called. Connection BeginTransaction Methods BeginTransaction():- Begins a transaction BeginTransaction(IsolationLevel):- Begins a transaction at the specified Isolation Level BeginTransaction (TransactionName)- transaction with the name specified in the Transaction Name string. BeginTransaction (IsolationLevel TransactionName):- Begins a transaction at the specified Isolation Level with the name specified in the Transaction Name string Refer http://www.15seconds.com/issue/040914.htm Thanks