The "PartitionKey" needs to be removed from the Queries in Lab 16/17 as when it is included, zero results are returned.

[gregoryagu]

Module: dp-420

Lab/Demo: 16/17 (same code is used on both labs)

Description of issue: There are coding issues that prevent the code from running as expected.

Repro steps:

1, Run the lab as instructed. No items are found in the queries.

The issue is that the PartitionKey parameter is included with the queries. With this removed, the queries run as expected. Example:

Line 661:
await productContainer.ReplaceItemAsync(
//partitionKey: new PartitionKey(categoryId),
id: product.id,
item: product);

When line 662 is commented out, it runs as expected.

Line 198 through 201 needs to be commented out:

FeedIterator resultSet = container.GetItemQueryIterator(
new QueryDefinition(sql)
.WithParameter("@id", customerId));
//requestOptions: new QueryRequestOptions()
//{
// PartitionKey = new PartitionKey(customerId)
//});

There are many other places in the file that use the same parameter that also need to be commented out.

Once I did this, I could run the lab as expected.