CODEWITHSUNDEEP
c#azureazure-table-storageazure-tablequery
Nuri Tasdemir
Nuri Tasdemir

Reputation: 9842

Getting first row in every partition in Azure Tables

I want to get only the first rows of every partition in Azure Tables. I can get all the data and then use the solution in this answer on that result. What I am asking is "Can I do that on Azure side without getting all that unnecessary results?"

Upvotes: 2

Views: 2167

Answers (1)

Gaurav Mantri
Gaurav Mantri

Reputation: 136346

Simple answer to your question is that without knowing the PartitionKey in advance, such operation is not possible from the Azure Table side. If you know the PartitionKey values, you can query on that value (RowKey is not required) and then get single result by specifying $top=1 (Take(1) in LINQ) as one of the querystring parameter.

Upvotes: 2

Related Questions