BigQueryParameterCollection Class

On this page

Collects all parameters relevant to a BigQueryCommand as well as their respective mappings to System.Data.DataSet columns.

Syntax

Visual Basic
C#


'Declaration Public NotInheritable Class BigQueryParameterCollection Inherits Devart.Data.SqlShimParameterCollection(Of BigQueryParameter) Implements System.Collections.ICollection, System.Collections.IEnumerable, System.Collections.IList, System.Data.IDataParameterCollection

'Declaration
 
Public NotInheritable Class BigQueryParameterCollection 
   Inherits Devart.Data.SqlShimParameterCollection(Of BigQueryParameter)
   Implements System.Collections.ICollection, System.Collections.IEnumerable, System.Collections.IList, System.Data.IDataParameterCollection


public sealed class BigQueryParameterCollection : Devart.Data.SqlShimParameterCollection<BigQueryParameter>, System.Collections.ICollection, System.Collections.IEnumerable, System.Collections.IList, System.Data.IDataParameterCollection

public sealed class BigQueryParameterCollection : Devart.Data.SqlShimParameterCollection<BigQueryParameter>, System.Collections.ICollection, System.Collections.IEnumerable, System.Collections.IList, System.Data.IDataParameterCollection

Remarks

The number of parameters in the collection must be equal to the number of parameter placeholders within the command text, or Google BigQuery raises an error.

Example

The following example adds instance of BigQueryParameter to collection.

csharp


public void AddBigQueryParameters() { // Create bigQueryConnection and bigQueryCommand. bigQueryCommand.CommandText = "DELETE Dept WHERE DeptNo = :DeptNo"; bigQueryCommand.Parameters.Add("DeptNo", BigQueryType.Int).Value = 50; bigQueryCommand.ExecuteNonQuery(); }

public void AddBigQueryParameters()
{
  // Create bigQueryConnection and bigQueryCommand.

  bigQueryCommand.CommandText = "DELETE Dept WHERE DeptNo = :DeptNo";
  bigQueryCommand.Parameters.Add("DeptNo", BigQueryType.Int).Value = 50;
  bigQueryCommand.ExecuteNonQuery();
}

Visual Basic


Public Sub AddBigQueryParameters() // Create bigQueryConnection and bigQueryCommand. bigQueryCommand.CommandText = "DELETE Dept WHERE DeptNo = :DeptNo" bigQueryCommand.Parameters.Add("DeptNo", BigQueryType.Int).Value = 50 bigQueryCommand.ExecuteNonQuery() End Sub 'AddBigQueryParameters

Public Sub AddBigQueryParameters()
  // Create bigQueryConnection and bigQueryCommand.

  bigQueryCommand.CommandText = "DELETE Dept WHERE DeptNo = :DeptNo"
  bigQueryCommand.Parameters.Add("DeptNo", BigQueryType.Int).Value = 50
  bigQueryCommand.ExecuteNonQuery()

End Sub 'AddBigQueryParameters

Inheritance Hierarchy

System.Object
   System.MarshalByRefObject
      System.Data.Common.DbParameterCollection
         Devart.Common.DbParameterBaseCollection
            Devart.Data.SqlShimParameterCollection<T>
               Devart.Data.BigQuery.BigQueryParameterCollection

Reference

BigQueryParameterCollection Members
Devart.Data.BigQuery Namespace
BigQueryParameter Class
BigQueryCommand Class

Send Feedback