Devart.Data.BigQuery.EFCore 1.0.248.11

dotConnect for Google BigQuery

dotConnect for Google BigQuery is an ADO.NET provider for working with Google BigQuery data through the standard ADO.NET or Entity Framework Core interfaces. It allows you to easily integrate BigQuery data into your .NET applications, and integrate BigQuery with widely used data-oriented technologies.

The product is compatible with Entity Framework (EF) Core. LINQ queries are translated to GoogleSQL; SaveChanges, Code-First migrations and scaffolding of an existing dataset are supported.

It has the same standard ADO.NET classes as other standard ADO.NET providers: BigQueryConnection, BigQueryCommand, BigQueryDataAdapter, BigQueryDataReader, BigQueryParameter, etc. This allows you quickly get started with it and eliminates the need to study any BigQuery API specificities.

More information at dotConnect for Google BigQuery.

Compatibility

The following table show which version of this package to use with which version of frameworks.

More information here

Installation

For projects, using Entity Framework Core 11 with BigQuery, install this package. Execute the following command in the Package Manager Console:

Install-Package Devart.Data.BigQuery.EFCore

License

See pricing options for ordering.

The NuGet package initiates the retrieval of an activation key from the Devart website. This key is required to activate the product for a free trial.

Usage

This snippet directly configures a BigQueryConnection class for an Entity Framework Core DbContext using a connection string.

public class MyDbContext : DbContext {

  protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) {

     optionsBuilder.UseBigQuery(@"Authentication Type=ServiceAccount;Service Account JSON=**********;Project Id=my-project;DataSet Id=my_dataset;");
  }
}

Configuration Using BigQueryConnection Instance

using Devart.Data.BigQuery;
...

public class MyDbContext : DbContext {

  protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) {

     var builder = new BigQueryConnectionStringBuilder();
     builder.AuthenticationType = AuthenticationType.ServiceAccount;
     builder.ServiceAccountJson = "**********";
     builder.ProjectId = "my-project";
     builder.DataSetId = "my_dataset";
     optionsBuilder.UseBigQuery(new BigQueryConnection(builder.ConnectionString));
  }
}

ASP.NET Core and Blazor

Configuration File (appsettings.json):

{
  "ConnectionStrings": {
    "DefaultConnection": "Authentication Type=ServiceAccount;Service Account JSON=**********;Project Id=my-project;DataSet Id=my_dataset;"
   }
}

DbContext Configuration:

public class MyDbContext : DbContext {

  protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) {

    IConfigurationBuilder builder = new ConfigurationBuilder().AddJsonFile("appsettings.json");
    IConfiguration configuration = builder.Build();
    optionsBuilder.UseBigQuery(configuration.GetConnectionString("DefaultConnection"));
  }
}

Key Features

• Easy Connection: Allows your .NET application to work with BigQuery data using a user account, a service account or interactive OAuth.
• GoogleSQL Translation: LINQ queries are translated to GoogleSQL and executed by BigQuery.
• Code-First and Scaffolding: Create tables from your model, or generate a model from an existing dataset.
• Support and Updates: Enjoy dedicated support team for prompt issue resolution and regular updates to keep your software running smoothly and securely.

Related Packages

• Devart.Data.BigQuery

Support Area

• Support
• Documentation
• Request form
• Feedback page
• Product history

More Resources

• Blog about dotConnect
• Devart Website