Property Value
The parameters of a SQL statement or a stored procedure. The default value is an empty collection.
The following example creates a
BigQueryConnection,
BigQueryCommand, fills its parameters and displays them. An UPDATE statement with the parameters involved is executed then.
|
|---|
static void CreateCommand(BigQueryConnection bigQueryConnection, string mySelectQuery, BigQueryParameter[] myParamArray)
{
BigQueryCommand bigQueryCommand = new BigQueryCommand(mySelectQuery, bigQueryConnection);
string myMessage = "";
for (int i = 0; i < myParamArray.Length; i++)
{
bigQueryCommand.Parameters.Add(myParamArray[i]);
myMessage += bigQueryCommand.Parameters[i].ToString() + "\n";
}
Console.Write(myMessage);
try
{
bigQueryConnection.Open();
bigQueryCommand.ExecuteNonQuery();
}
finally
{
bigQueryConnection.Close();
}
}
static void Main(string[] args)
{
BigQueryParameter[] myParams = new BigQueryParameter[]
{
new BigQueryParameter("DeptNo", 10),
new BigQueryParameter("DName", "COUNTING")
};
BigQueryConnection bigQueryConnection1 = new BigQueryConnection(
@"Authentication Type=ServiceAccount;ServiceAccount Json=C:\keys\service-account.json;Project Id=your_project;DataSet Id=your_dataset;License Key=**********");
CreateCommand(bigQueryConnection1,"UPDATE Dept SET DName = :DName WHERE DeptNo = :DeptNo",myParams);
} |
|
|---|
Public Sub CreateCommand(ByVal bigQueryConnection As Devart.Data.BigQuery.BigQueryConnection, _
ByVal mySelectQuery As String, ByVal myParamArray() As Devart.Data.BigQuery.BigQueryParameter)
Dim bigQueryCommand As New Devart.Data.BigQuery.BigQueryCommand(mySelectQuery, bigQueryConnection)
Dim myMessage As String = ""
Dim i As Integer
For i = 0 To (myParamArray.Length - 1)
bigQueryCommand.Parameters.Add(myParamArray(i))
myMessage = String.Concat(myMessage, " ", bigQueryCommand.Parameters(i).ToString())
Next
Console.WriteLine(myMessage)
Try
bigQueryConnection.Open()
bigQueryCommand.ExecuteNonQuery()
Finally
bigQueryConnection.Close()
End Try
End Sub
Sub Main()
Dim myP1 As New Devart.Data.BigQuery.BigQueryParameter
myP1.ParameterName = "DeptNo"
myP1.Value = 10
Dim myP2 As New Devart.Data.BigQuery.BigQueryParameter
myP2.ParameterName = "DName"
myP2.Value = "ACCOUNTING"
Dim myParams(1) As Devart.Data.BigQuery.BigQueryParameter
myParams(0) = myP1
myParams(1) = myP2
Dim bigQueryConnection1 As New Devart.Data.BigQuery.BigQueryConnection( _
"Authentication Type=ServiceAccount;ServiceAccount Json=C:\keys\service-account.json;Project Id=your_project;DataSet Id=your_dataset;License Key=**********")
CreateCommand(bigQueryConnection1, "UPDATE Dept SET DName = :DName WHERE DeptNo = :DeptNo", myParams)
End Sub |
