How do you pass a PartitionKey to Execute a StoredProcedure?

Question

I'm trying to execute a stored procedure on a partitioned collection (server side partitioning) from the .net SDK (v1.6.3).

await client.ExecuteStoredProcedureAsync<string>(UriFactory.CreateStoredProcedureUri("db0", "collection0", "testsproc0"), storedProcedureParams);

I receive the error "PartitionKey value must be supplied for this operation". In fact, I see this error in the Azure Portal when I play around with the Script Explorer. However, I see no way to add a PartitionKey. Is this a limitation with the API and partitioned collections right now, or am I missing something?

Answer 1

you can pass in the partition key by using the overloaded ExecuteStoredProcedureAsync method with RequestOptions. For example,

await client.ExecuteStoredProcedureAsync<DeviceSignal>(
UriFactory.CreateStoredProcedureUri("db", "coll", "SetLatestStateAcrossReadings"),
new RequestOptions { PartitionKey = new PartitionKey("XMS-001") }, sprocsParams);