Questo articolo è stato tradotto automaticamente. Per visualizzare l'articolo in inglese, selezionare la casella di controllo Inglese. È possibile anche visualizzare il testo inglese in una finestra popup posizionando il puntatore del mouse sopra il testo.
Traduzione
Inglese

Metodo SqlConnection.BeginTransaction (IsolationLevel, String)

 

Data di pubblicazione: ottobre 2016

Inizia una transazione di database con il nome della transazione e il livello di isolamento specificato.

Spazio dei nomi:   System.Data.SqlClient
Assembly:  System.Data (in System.Data.dll)

public SqlTransaction BeginTransaction(
	IsolationLevel iso,
	string transactionName
)

Parametri

iso
Type: System.Data.IsolationLevel

Livello di isolamento in cui eseguire la transazione.

transactionName
Type: System.String

Nome della transazione.

Valore restituito

Type: System.Data.SqlClient.SqlTransaction

Oggetto che rappresenta la nuova transazione.

Exception Condition
SqlException

Le transazioni parallele non sono consentite quando si usa MARS (Multiple Active Result Sets).

InvalidOperationException

Le transazioni parallele non sono supportate.

This command maps to the ssNoVersion implementation of BEGIN TRANSACTION.

The value in the transactionName parameter can be used in later calls to M:System.Data.SqlClient.SqlTransaction.Rollback and in the savePoint parameter of the M:System.Data.SqlClient.SqlTransaction.Save(System.String) method.

You must explicitly commit or roll back the transaction using the M:System.Data.SqlClient.SqlTransaction.Commit or M:System.Data.SqlClient.SqlTransaction.Rollback method. To make sure that the ssNoVersion transaction management model performs correctly, avoid using other transaction management models, such as the one provided by ssNoVersion.

System_CAPS_noteNota

After a transaction is committed or rolled back, the isolation level of the transaction persists for all subsequent commands that are in autocommit mode (the ssNoVersion default). This can produce unexpected results, such as an isolation level of REPEATABLE READ persisting and locking other users out of a row. To reset the isolation level to the default (READ COMMITTED), execute the tsql SET TRANSACTION ISOLATION LEVEL READ COMMITTED statement, or call M:System.Data.SqlClient.SqlConnection.BeginTransaction followed immediately by M:System.Data.SqlClient.SqlTransaction.Commit. For more information on ssNoVersion isolation levels, see "Isolation Levels in the Database Engine" in ssNoVersion Books Online.

For more information on ssNoVersion transactions, see "Explicit Transactions" and "Coding Efficient Transactions" in ssNoVersion Books Online.

System_CAPS_cautionAttenzione

When your query returns a large amount of data and calls BeginTransaction, a T:System.Data.SqlClient.SqlException is thrown because ssNoVersion does not allow parallel transactions when using MARS. To avoid this problem, always associate a transaction with the command, the connection, or both before any readers are open.

The following example creates a T:System.Data.SqlClient.SqlConnection and a T:System.Data.SqlClient.SqlTransaction. It also demonstrates how to use the M:System.Data.SqlClient.SqlConnection.BeginTransaction, a M:System.Data.SqlClient.SqlTransaction.Commit, and M:System.Data.SqlClient.SqlTransaction.Rollback methods.

private static void ExecuteSqlTransaction(string connectionString)
{
    using (SqlConnection connection = new SqlConnection(connectionString))
    {
        connection.Open();

        SqlCommand command = connection.CreateCommand();
        SqlTransaction transaction;

        // Start a local transaction.
        transaction = connection.BeginTransaction(
            IsolationLevel.ReadCommitted, "SampleTransaction");

        // Must assign both transaction object and connection
        // to Command object for a pending local transaction.
        command.Connection = connection;
        command.Transaction = transaction;

        try
        {
            command.CommandText =
                "Insert into Region (RegionID, RegionDescription) VALUES (100, 'Description')";
            command.ExecuteNonQuery();
            command.CommandText =
                "Insert into Region (RegionID, RegionDescription) VALUES (101, 'Description')";
            command.ExecuteNonQuery();
            transaction.Commit();
            Console.WriteLine("Both records are written to database.");
        }
        catch (Exception e)
        {
            try
            {
                transaction.Rollback();
            }
            catch (SqlException ex)
            {
                if (transaction.Connection != null)
                {
                    Console.WriteLine("An exception of type " + ex.GetType() +
                        " was encountered while attempting to roll back the transaction.");
                }
            }

            Console.WriteLine("An exception of type " + e.GetType() +
                " was encountered while inserting the data.");
            Console.WriteLine("Neither record was written to database.");
        }
    }
}

.NET Framework
Disponibile da 1.1
Torna all'inizio
Mostra: