CreateCommand Method (BigQueryConnection)

On this page

Creates and returns a BigQueryCommand object associated with the BigQueryConnection.

Syntax

Visual Basic
C#


'Declaration Public Shadows Function CreateCommand() As BigQueryCommand


public new BigQueryCommand CreateCommand()

Return Value

A BigQueryCommand object.

Remarks

You can use this method as an alternative to common BigQueryCommand constructors.

Example

In this sample BigQueryCommand object is created. It is automatically associated with BigQueryConnection that created it.

csharp


public void CreateBigQueryCommand(string myConnString) { BigQueryConnection bigQueryConnection = new BigQueryConnection(myConnString); BigQueryCommand bigQueryCommand = bigQueryConnection.CreateCommand(); bigQueryCommand.CommandText = "INSERT INTO your_project.your_dataset.employees (first_name, last_name) VALUES ('John', 'Smith')"; bigQueryConnection.Open(); try { bigQueryCommand.ExecuteNonQuery(); } finally { bigQueryConnection.Close(); } }

public void CreateBigQueryCommand(string myConnString)
{
  BigQueryConnection bigQueryConnection = new BigQueryConnection(myConnString);
  BigQueryCommand bigQueryCommand = bigQueryConnection.CreateCommand();
  bigQueryCommand.CommandText = "INSERT INTO your_project.your_dataset.employees (first_name, last_name) VALUES ('John', 'Smith')";
  bigQueryConnection.Open();
  try
  {
    bigQueryCommand.ExecuteNonQuery();
  }
  finally
  {
    bigQueryConnection.Close();
  }
}

Visual Basic


Public Sub CreateBigQueryCommand(ByVal myConnString As String) Dim bigQueryConnection As New BigQueryConnection(myConnString) Dim bigQueryCommand As BigQueryCommand = bigQueryConnection.CreateCommand() bigQueryCommand.CommandText = "INSERT INTO your_project.your_dataset.employees (first_name, last_name) VALUES ('John', 'Smith')" bigQueryConnection.Open() Try bigQueryCommand.ExecuteNonQuery() Finally bigQueryConnection.Close() End Try End Sub

Public Sub CreateBigQueryCommand(ByVal myConnString As String)
  Dim bigQueryConnection As New BigQueryConnection(myConnString)
  Dim bigQueryCommand As BigQueryCommand = bigQueryConnection.CreateCommand()
  bigQueryCommand.CommandText = "INSERT INTO your_project.your_dataset.employees (first_name, last_name) VALUES ('John', 'Smith')"
  bigQueryConnection.Open()
  Try
    bigQueryCommand.ExecuteNonQuery()
  Finally
    bigQueryConnection.Close()
  End Try
End Sub

Reference

BigQueryConnection Class
BigQueryConnection Members
BigQueryCommand Class

Send Feedback