How to Skip, Take and Orderby using Azure.Data.Tables?

Question

Microsoft suggests azure.data.tables nuget and namespace instead of older microsoft.azure.cosmos.table namespace but it is not well documented and I cannot find more information beside their Github page. Here they described basic querying but my question is; is it possible to get sorted and filtered entities from the server, not on the client side?

For example with the other library it is possible to use TableQuery and do take, orderby operations like described here

What i am trying to achieve it basically

var result= query.OrderByDescending(l => l.Timestamp).Skip((pagenumber- 1) * count.Value).Take(count.Value);

Is it possible to achieve this query on the server side using Azure.Data.Tables namespace?

Gaurav Mantri · Accepted Answer · 2021-12-10 16:05:38Z

1

Only thing you can use from these operators is “Take” because other two operators are not supported by Azure Table Storage.

For the list of supported LINQ operators with Azure Table Storage, please see this link: https://learn.microsoft.com/en-us/rest/api/storageservices/query-operators-supported-for-the-table-service.

answered Dec 10, 2021 at 16:05

Gaurav Mantri

137k17 gold badges247 silver badges282 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Emil Over a year ago

so you mean that we can only on the client side. but other library is supporting and rest api is also possible? that means technically it is implemented but maybe not with the Azure.data.tables library

Emil Over a year ago

Ops just saw the annotation that only works with CosmosDb endpoints :(

Gaurav Mantri Over a year ago

Yeah, that's correct. Azure Storage Tables does not support it. I am not sure if Azure Cosmos DB Table API support it either (I may be wrong though).

qJake Over a year ago

So, this is fine for Azure Storage, but how about if we are using Azure Cosmos DB Table API? The best practice is to use Azure.Data.Tables as the client for Cosmos, and Cosmos supports OrderBy, so why doesn't this client?

Hugobop · Accepted Answer · 2022-08-19 22:22:45Z

0

I am in a similar situation and I came across these articles:

The methods he describes is a hack and will take some thought as to how to apply to your situation. Thought I'd put it up here in case anyone ends up on this page.

answered Aug 19, 2022 at 22:22

Hugobop

5507 silver badges13 bronze badges

Collectives™ on Stack Overflow

How to Skip, Take and Orderby using Azure.Data.Tables?

2 Answers 2

4 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related