public void Insert()
{
string projectId = _fixture.ProjectId;
string datasetId = _fixture.GameDatasetId;
string tableId = _fixture.HistoryTableId;
BigqueryTable table = BigqueryClient.Create(projectId).GetTable(datasetId, tableId);
int rowsBefore = table.ListRows().Rows.Count();
// Snippet: Insert(string,string,*)
BigqueryClient client = BigqueryClient.Create(projectId);
// The insert ID is optional, but can avoid duplicate data
// when retrying inserts.
InsertRow row1 = new InsertRow("row1")
{
{ "player", "Jane" },
{ "level", 3 },
{ "score", 3600 },
{ "game_started", DateTime.UtcNow }
};
InsertRow row2 = new InsertRow("row2")
{
{ "player", "Jeff" },
{ "level", 2 },
{ "score", 2000 },
{ "game_started", DateTime.UtcNow }
};
client.Insert(datasetId, tableId, row1, row2);
// End snippet
int rowsAfter = table.ListRows().Rows.Count();
Assert.Equal(rowsBefore + 2, rowsAfter);
}
