Shulou(Shulou.com)06/02 Report--

ADO.NET transaction processing is how, many novices are not very clear about this, in order to help you solve this problem, the following editor will explain for you in detail, people with this need can come to learn, I hope you can gain something.

When learning ADO.NET, you may encounter ADO.NET transaction processing problems. Here we will introduce the solutions to ADO.NET transaction processing problems and share them with you here. In the process of application data processing, we often encounter a situation: when a certain data changes, the relevant data can not be updated in time, resulting in data inconsistency and even serious errors.

For example, in a sales system, the data processing of the sales table is completed through the bill processing module, and the client sales staff has sold the goods in stock, but the inventory table related to the sales table has not been updated in time. As a result, if you marry her salesperson and read the inventory data, there will be data inconsistencies.

For this reason, we introduce the concept of transaction into the basic theory of database. The so-called transaction is such a series of operations, these operations are regarded as a sequence of operations, either all or all, is an indivisible program unit. Data update events often occur in database data processing. in order to ensure the security and consistency of data operations, large database servers support transaction processing to ensure that data updates are carried out within a controllable range. ADO.NET supports transactions through the BeginTransaction () method of the Connection object, which returns an object that implements the IDbTransaction interface, which is defined in System.Data.

1.ADO.NET transaction command

Calling the BeginTransaction () method of the Connection object returns a DbTransaction object. Common transaction commands for DbTransaction objects include the following three:

◆ nBegin: before performing any operation in a transaction, you must use the Begin command to start the transaction

◆ nCommit: the transaction is committed only when all changes are successfully stored in the database

◆ nRollback: rollback occurs because an operation fails during a transaction and cancels all modifications made by the transaction

DbTransaction class names are different and representations are different in different namespaces. See table:

Class

Description

OdbcTransaction

Represents a SQL transaction to an Odbc data source.

OleDbTransaction

Represents a SQL transaction to an OleDb data source.

OracleTransaction

Represents a transaction to an Oracle database.

SqlTransaction

Represents the Transact-SQL transaction to be performed on the SQL Server database.

Table A table of DbTransaction classes in different namespaces.

In the following content, we focus on the SqlTransaction object.

The use of 2.SqlTransaction objects

The SqlTransaction object represents the transaction to be performed on the data source, and its common property is Connection. The Connection property is used to get the SqlConnection object associated with the transaction, or a null reference if the transaction is no longer valid. The common methods for SqlTransaction objects are Save (), Commit (), and Rollback (), where the Save () method creates a save point in the transaction (which can be used to roll back part of the transaction) and specifies the save point name; the Commit () method is used to commit the database transaction, and the Rollback () method rolls back the transaction from the pending state.

Is it helpful for you to read the above content? If you want to know more about the relevant knowledge or read more related articles, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.