Windows Azure Table Storage int field increment
azure, azure-storage, azure-table-storage
Solution
You can accomplish this with either Table or Page storage with ETAG tracking enabled. I use this technique to create an Identity value for each entry in Azure Table. The idea goes like this:
Read the value from the Page Blob, leave ETAG tracking enabled
Increment the retrieved value
POST the retrieved value, and if there is an ETAG conflict, retry the whole operation again fresh. Perhaps use an exponential backoff algorithm here to prevent overloading the target container or partition.
Problem
I thinking about great improvement of Azure Table Storage. Is it possible to submit query to Table Storage with specific operation such as "increment entity field [name] by [value] where [PartitionKey=somestingPK] and [RowKey=somethingRK]"? @smarx is this feature will be available?