Search code examples
c#azureazure-storagelimitazure-table-storage

How to get more than 1000 entities from an azure table storage query?


I have read that azure table storage queries give maximum of 1000 entities and we have to make use of continuation tokens to fetch the next set of entities. I am just looking for an easy way to do that. All I want to do is fetch all the entities that the query should actually return and not just the 1000 entities. I have read @smarx post here and he mentions about ExecuteAll method in TableStorageDataServiceQuery but this seems to have deprecated as I cant find TableStorageDataServiceQuery in the storage client library.

I also found this msdn documentation on how to handle the continuation tokens to fetch all the entities. I just want to know if this is the best way to get all the entities, I dont need any pagination. Or is there any ExecuteAll esque method that I can use?


Solution

  • Using the AsTableServiceQuery like so:

    var data = context.CreateQuery<SomeEntity>("table").AsTableServiceQuery<SomeEntity>().Execute();