ADO.NET 对 Microsoft SQL Server 的事务逻辑

最新推荐文章于 2025-11-15 16:15:41 发布

原创最新推荐文章于 2025-11-15 16:15:41 发布 · 850 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#microsoft #sql server #insert #command #exception

本文通过一个具体的示例演示了如何使用SQL事务来确保数据库操作的一致性和完整性。包括开启事务、执行插入操作、提交或回滚事务等关键步骤。

Using connection As SqlConnection = New SqlConnection(connectString)
    connection.Open()

    ' Start a local transaction.
    Dim sqlTran As SqlTransaction = connection.BeginTransaction()

    ' Enlist the command in the current transaction.
    Dim command As SqlCommand = connection.CreateCommand()
    command.Transaction = sqlTran

    Try
        command.CommandText = _
          "INSERT INTO Production.ScrapReason(Name) VALUES('Wrong size')"
        command.ExecuteNonQuery()
        command.CommandText = _
          "INSERT INTO Production.ScrapReason(Name) VALUES('Wrong color')"
        command.ExecuteNonQuery()
        sqlTran.Commit()
        Console.WriteLine("Both records were written to database.")
    Catch ex As Exception
        Console.WriteLine(ex.Message)
        Console.WriteLine("Neither record was written to database.")
        sqlTran.Rollback()
    End Try
End Using