BeginTransaction() Method

On this page

Begins a database transaction.

Syntax

Visual Basic
C#


'Declaration Public Overloads Shadows Function BeginTransaction() As BigQueryTransaction


public new BigQueryTransaction BeginTransaction()

Return Value

An object representing the new transaction.

Remarks

To commit or roll back the transaction, you must explicitly use the Devart.Data.BigQuery.BigQueryConnection.Commit() or Devart.Data.BigQuery.BigQueryConnection.Rollback() methods.

Example

The following example creates a BigQueryConnection and a BigQueryTransaction. It also demonstrates how to use the BeginTransaction(), Devart.Data.BigQuery.BigQueryConnection.Commit, and Devart.Data.BigQuery.BigQueryConnection.Rollback methods.

csharp


public void RunBigQueryTransaction(string myConnString) { BigQueryConnection bigQueryConnection = new BigQueryConnection(myConnString); bigQueryConnection.Open(); BigQueryCommand bigQueryCommand = new BigQueryCommand(); bigQueryCommand.Connection = bigQueryConnection; BigQueryTransaction myTrans; // Start a local transaction myTrans = bigQueryConnection.BeginTransaction(); // Assign transaction object for a pending local transaction bigQueryCommand.Transaction = myTrans; try { bigQueryCommand.CommandText = "INSERT INTO Dept(DeptNo, DName) Values(50, 'DEVELOPMENT')"; bigQueryCommand.ExecuteNonQuery(); bigQueryCommand.CommandText = "INSERT INTO Dept(DeptNo, DName) Values(60, 'PRODUCTION')"; bigQueryCommand.ExecuteNonQuery(); myTrans.Commit(); Console.WriteLine("Both records are written to database."); } catch(Exception e) { myTrans.Rollback(); Console.WriteLine(e.ToString()); Console.WriteLine("Neither record was written to database."); } finally { bigQueryConnection.Close(); } }

public void RunBigQueryTransaction(string myConnString)
{
  BigQueryConnection bigQueryConnection = new BigQueryConnection(myConnString);
  bigQueryConnection.Open();

  BigQueryCommand bigQueryCommand = new BigQueryCommand();
  bigQueryCommand.Connection = bigQueryConnection;
  BigQueryTransaction myTrans;

  // Start a local transaction
  myTrans = bigQueryConnection.BeginTransaction();
  // Assign transaction object for a pending local transaction
  bigQueryCommand.Transaction = myTrans;

  try
  {
    bigQueryCommand.CommandText = "INSERT INTO Dept(DeptNo, DName) Values(50, 'DEVELOPMENT')";
    bigQueryCommand.ExecuteNonQuery();
    bigQueryCommand.CommandText = "INSERT INTO Dept(DeptNo, DName) Values(60, 'PRODUCTION')";
    bigQueryCommand.ExecuteNonQuery();
    myTrans.Commit();
    Console.WriteLine("Both records are written to database.");
  }
  catch(Exception e)
  {
    myTrans.Rollback();
    Console.WriteLine(e.ToString());
    Console.WriteLine("Neither record was written to database.");
  }
  finally
  {
    bigQueryConnection.Close();
  }
}

Visual Basic


Public Sub RunBigQueryTransaction(myConnString As String) Dim bigQueryConnection As New BigQueryConnection(myConnString) bigQueryConnection.Open() Dim bigQueryCommand As New BigQueryCommand() bigQueryCommand.Connection = bigQueryConnection Dim myTrans As BigQueryTransaction ' Start a local transaction myTrans = bigQueryConnection.BeginTransaction() ' Assign transaction object for a pending local transaction bigQueryCommand.Transaction = myTrans Try bigQueryCommand.CommandText = "INSERT INTO Dept(DeptNo, DName) Values(50, 'DEVELOPMENT')" bigQueryCommand.ExecuteNonQuery() bigQueryCommand.CommandText = "INSERT INTO Dept(DeptNo, DName) Values(60, 'PRODUCTION')" bigQueryCommand.ExecuteNonQuery() myTrans.Commit() Console.WriteLine("Both records are written to database.") Catch e As Exception myTrans.Rollback() Console.WriteLine(e.ToString()) Console.WriteLine("Neither record was written to database.") Finally bigQueryConnection.Close() End Try End Sub

Public Sub RunBigQueryTransaction(myConnString As String)
  Dim bigQueryConnection As New BigQueryConnection(myConnString)
  bigQueryConnection.Open()

  Dim bigQueryCommand As New BigQueryCommand()
  bigQueryCommand.Connection = bigQueryConnection
  Dim myTrans As BigQueryTransaction

  ' Start a local transaction
  myTrans = bigQueryConnection.BeginTransaction()
  ' Assign transaction object for a pending local transaction
  bigQueryCommand.Transaction = myTrans

  Try
    bigQueryCommand.CommandText = "INSERT INTO Dept(DeptNo, DName) Values(50, 'DEVELOPMENT')"
    bigQueryCommand.ExecuteNonQuery()
    bigQueryCommand.CommandText = "INSERT INTO Dept(DeptNo, DName) Values(60, 'PRODUCTION')"
    bigQueryCommand.ExecuteNonQuery()
    myTrans.Commit()
    Console.WriteLine("Both records are written to database.")
  Catch e As Exception
    myTrans.Rollback()
    Console.WriteLine(e.ToString())
    Console.WriteLine("Neither record was written to database.")
  Finally
    bigQueryConnection.Close()
  End Try
End Sub

Reference

BigQueryConnection Class
BigQueryConnection Members
Overload List
BigQueryCommand Class
BigQueryTransaction Class
Devart.Data.BigQuery.BigQueryConnection.Commit
Devart.Data.BigQuery.BigQueryConnection.Rollback

Send Feedback