azure table batch operation with different parition key

Question

I am new to Azure development (c#). I want to insert some entities to Azure table using TableBatchOperation. I am using the id of the entities as partition key. However, in a batch operation, the partition keys have to be the same. On the other hand, I do not want to perform single TableOperation in a loop as that will be a performance bottleneck. Can anyone suggest any work-around how can I save my entities as a Batch Operation which have different partition keys?

Answer 1

There is no way to do this. The reason the partition key even exists is that Azure can distribute data across machines with no coordination between partitions. The system is designed such that different partitions cannot be used in the same transaction or operation.