Skip to content
This repository was archived by the owner on Jun 27, 2022. It is now read-only.

whitesharx/bigquery-hla

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

26 Commits
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

bigquery-hla

An easy to use Google BigQuery database connector

Features:

Query

var dataModels = await new BigQueryContext("projectId", "dataset", "Creds/creds.json").Query<MyDataModel>("SELECT * FROM `my-dataset.my-table` WHERE name = @Name", new { Name = "Alex" })

Insert

await new BigQueryContext("projectId", "dataset", "Creds/creds.json").GetTable<MyDataModel>("my-table").InsertMany(dataModels);

Merge

await new BigQueryContext("projectId", "dataset", "Creds/creds.json").GetTable<MyDataModel>("my-table").Upsert<MyDataModel>(dataModels, new Expression<Func<T, object>>[]{x => x.Id}, new Expression<Func<T, object>>[]{x => x.Name, x.Age})

Attributes for data model members:

[BigQueryPartition] - defines partition and it's type

[BigQueryIgnore] - ignores member

Changelog:

0.0.7 - Improved concurrency 0.0.6 - Added BigContext.Query( ) method; improved mapping

About

High-Level API for BigQuery

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Contributors 2

  •  
  •  

Languages