dotConnect for Google BigQuery

.NET 11 available

Install-Package Devart.Data.BigQuery

Supported Platforms

.NET connector for Google BigQuery with ORM support

dotConnect for Google BigQuery is an ADO.NET provider that enables .NET applications to connect to Google BigQuery and work with cloud-based analytical data. It provides direct access to BigQuery through standard ADO.NET interfaces, supports modern .NET platforms, and integrates with popular development tools and ORM frameworks.

Integration with Entity Framework Core, Dapper, and NHibernate
Full compliance with ADO.NET standards
Secure HTTPS connectivity and Google Cloud authentication
Support for Google BigQuery data types and GoogleSQL queries
Integration with Microsoft Visual Studio and design-time tools

Trouble-free connection to Google BigQuery

dotConnect for Google BigQuery enables .NET applications to access BigQuery without requiring additional native client libraries. Developers can configure Google Cloud authentication, establish connections, execute SQL queries, and retrieve analytical data using familiar ADO.NET components.

C# Copy code

using Devart.Data.BigQuery;

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

C# Copy code

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();
  }
}

C# Copy code

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();
  }
}

Direct access to Google BigQuery without additional native libraries
Support for GoogleSQL queries and BigQuery-specific data types
Secure authentication using Google Cloud service accounts, OAuth 2.0 refresh tokens, or interactive Google sign-in
Flexible connection configuration, including proxy settings
Integration with existing .NET applications

Connection details

Advanced ORM support

dotConnect for Google BigQuery supports popular ORM frameworks and integrates with Entity Developer, Devart's visual ORM designer, available as a separate product. Developers can use familiar object-oriented approaches to access and process BigQuery data within .NET applications.

Entity Framework Core

3.1, 8-11

NHibernate

1.x-5.x

Dapper

1.x, 2.x

Entity Developer helps developers generate entity classes and data access models from existing database structures, reducing manual coding and simplifying application maintenance.

Explore the features

Advanced ORM support in dotConnect for Google BigQuery

Speed and reliability in perfect harmony

dotConnect for Google BigQuery provides efficient data access for .NET applications working with analytical workloads. Asynchronous query execution helps keep applications responsive while retrieving data, and the provider retrieves large query results page by page automatically.

The provider also offers error handling and diagnostic capabilities to help identify connection issues, investigate query failures, and maintain reliable data access.

Performance details

Compatibility and integration

Platforms

.NET 5.0-11.0
.NET Framework 4.6.1-4.8
.NET Core 2.0-3.1

Data source

Google BigQuery (GoogleSQL and Legacy SQL)

Visual Studio integration

Data source connections
Database object exploration
Data retrieval and display
Design-time data access components

ORM integration

Entity Framework Core
NHibernate
Dapper

Compatibility details

Features

Secure connectivity and configuration

Connect to Google BigQuery over HTTPS using service account or OAuth 2.0 credentials. Configure project, dataset, and proxy settings to support secure access across application environments.

GoogleSQL and data type support

Run GoogleSQL queries natively, with Legacy SQL available as an option. Work with BigQuery types such as BIGNUMERIC, JSON, GEOGRAPHY, INTERVAL, and RANGE through standard ADO.NET interfaces.

In-memory data management

Retrieve and manage query results with ADO.NET DataSet and DataTable components. Support data binding, in-memory processing, and disconnected access to BigQuery data in .NET applications.

Large dataset processing

Process large query results through automatic pagination and load data in bulk with BigQueryLoader. Move data between BigQuery and .NET applications for reporting, integration, and analytics.

Transactions

Use BigQueryTransaction or TransactionScope to manage server-side transactions through BigQuery sessions. Group supported operations into transactions to maintain data consistency in .NET applications.

Visual Studio integration

Configure connections, explore BigQuery objects, and access data through Visual Studio design-time tools. Simplify development of BigQuery-connected .NET applications with visual configuration.

Leading companies choose dotConnect

Other .NET connectors for databases

DB2

MongoDB

MySQL

Oracle

PostgreSQL

SQL Server

SQLite