Program.cs

/*
 * Copyright (c) 2018 Google LLC
 *
 * Licensed under the Apache License, Version 2.0 (the "License"); you may not
 * use this file except in compliance with the License. You may obtain a copy of
 * the License at
 *
 * http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS, WITHOUT
 * WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the
 * License for the specific language governing permissions and limitations under
 * the License.
 */
// [START bigquery_simple_app_all]
// [START bigquery_simple_app_deps]

usingSystem;
usingGoogle.Cloud.BigQuery.V2;
// [END bigquery_simple_app_deps]

namespaceGoogleCloudSamples
{
publicclassProgram
{
publicstaticvoidMain(string[]args)
{
// [START bigquery_simple_app_client]
stringprojectId=Environment.GetEnvironmentVariable("GOOGLE_PROJECT_ID");
varclient=BigQueryClient.Create(projectId);
// [END bigquery_simple_app_client]
// [START bigquery_simple_app_query]
stringquery=@"SELECT
 CONCAT(
 'https://stackoverflow.com/questions/',
 CAST(id as STRING)) as url, view_count
 FROM `bigquery-public-data.stackoverflow.posts_questions`
 WHERE tags like '%google-bigquery%'
 ORDER BY view_count DESC
 LIMIT 10";
varresult=client.ExecuteQuery(query,parameters:null);
// [END bigquery_simple_app_query]
// [START bigquery_simple_app_print]
Console.Write("\nQuery Results:\n------------\n");
foreach(varrowinresult)
{
Console.WriteLine($"{row["url"]}: {row["view_count"]} views");
}
// [END bigquery_simple_app_print]
}
}
}
// [END bigquery_simple_app_all]