Getting Started With dotConnect for Google BigQuery

using Devart.Data.BigQuery;

class Program
{
  static void Main()
  {
    using BigQueryConnection conn = new(
      "Authentication Type=UserAccount;" +
      "Project Id=your_project_id;" +
      "Client Id=your_client_id;" +
      "Client Secret=your_client_secret;" +
      "Refresh Token=your_refresh_token;" +
      "License Key=your_license_key");
    conn.Open();
  }
}

using Devart.Data.BigQuery;

class Program
{
  static void Main()
  {
    using BigQueryConnection conn = new(
      "Authentication Type=UserAccountInteractive;" +
      "Project Id=your_project_id;" +
      "License Key=your_license_key");
    conn.Open();
  }
}

using Devart.Data.BigQuery;
using System;

class Program
{
  static void Main()
  {
    using BigQueryConnection conn = new(
      "Authentication Type=ServiceAccount;" +
      "Project Id=your_project_id;" +
      "DataSet Id=your_data_set_id;" +
      "ServiceAccount Json=your_service_account_json;" +
      "License Key=your_license_key");
    conn.Open();

    using BigQueryCommand cmd = new("SELECT id, name FROM orders", conn);
    using BigQueryDataReader reader = cmd.ExecuteReader();
    while (reader.Read())
    {
      Console.WriteLine(reader["name"]);
    }
  }
}

using Devart.Data.BigQuery;
using System;

class Program
{
  static void Main()
  {
    using BigQueryConnection conn = new(
      "Authentication Type=ServiceAccount;" +
      "Project Id=your_project_id;" +
      "DataSet Id=your_data_set_id;" +
      "ServiceAccount Json=your_service_account_json;" +
      "License Key=your_license_key");
    conn.Open();

    using BigQueryCommand cmd = new("SELECT id, name FROM orders WHERE id = @id", conn);
    cmd.Parameters.Add(new BigQueryParameter { ParameterName = "id", Value = 1 });
    using BigQueryDataReader reader = cmd.ExecuteReader();
    while (reader.Read())
    {
      Console.WriteLine(reader["name"]);
    }
  }
}

using Devart.Data.BigQuery;
using System.Data;

class Program
{
  static void Main()
  {
    using BigQueryConnection conn = new(
      "Authentication Type=ServiceAccount;" +
      "Project Id=your_project_id;" +
      "DataSet Id=your_data_set_id;" +
      "ServiceAccount Json=your_service_account_json;" +
      "License Key=your_license_key");
    conn.Open();

    using BigQueryDataAdapter adapter = new("SELECT id, name FROM orders", conn);
    DataTable table = new();
    adapter.Fill(table);
  }
}

using Devart.Data.BigQuery;
using Microsoft.EntityFrameworkCore;
using System.ComponentModel.DataAnnotations.Schema;
using System.Linq;

[Table("orders")]
class Order
{
  public long Id { get; set; }
  public string Name { get; set; }
}

class AppDbContext : DbContext
{
  public DbSet<Order> Orders { get; set; }

  protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
  {
    optionsBuilder.UseBigQuery(
      "Authentication Type=ServiceAccount;" +
      "Project Id=your_project_id;" +
      "DataSet Id=your_data_set_id;" +
      "ServiceAccount Json=your_service_account_json;" +
      "License Key=your_license_key");
  }
}

class Program
{
  static void Main()
  {
    using AppDbContext db = new();
    var orders = db.Orders.Where(o => o.Id > 0).ToList();
  }
}

using Devart.Data.BigQuery;

class Program
{
  static void Main()
  {
    using BigQueryConnection conn = new(
      "Authentication Type=ServiceAccount;" +
      "Project Id=your_project_id;" +
      "DataSet Id=your_data_set_id;" +
      "ServiceAccount Json=your_service_account_json;" +
      "Default Cloud Storage Bucket=your_bucket_name;" +
      "License Key=your_license_key");
    conn.Open();

    BigQueryLoader loader = new("orders", conn);
    loader.CreateColumns();
    loader.Open();
    loader.SetValue(0, 1);
    loader.SetValue(1, "Order 1");
    loader.NextRow();
    loader.Close();
  }
}