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