private int ExecuteNonQuery(PostGresQueryBuilder query)
{
int result;
OpenConnection();
using (var command = new NpgsqlCommand(query.GetQuery(), this._connection, this._transaction))
{
result = command.ExecuteNonQuery();
}
return(result);
}
private void WriteDataToStream <T>(string index, List <T> Items, PostGresQueryBuilder query) where T : class, IRepositoryItem
{
this.OpenConnection();
using (var writer = _connection.BeginBinaryImport(query.GetQuery()))
{
foreach (var Item in Items)
{
writer.StartRow();
writer.Write(Item.GetId(), NpgsqlDbType.Varchar);
writer.Write(index, NpgsqlDbType.Varchar);
writer.Write(Item.CompanyId, NpgsqlDbType.Varchar);
writer.Write(Item.ProjectId, NpgsqlDbType.Varchar);
writer.Write(JsonConvert.SerializeObject(Item), NpgsqlDbType.Jsonb);
}
writer.Complete();
}
}