how to read the no of rows of a windows azure table storage?

Question

How can i get to know the no: of rows of my windows azure table through coding. Is there any upper limit for windows azure table storage?

 

Thanks in advance,

Hpv

Answer 1

Upper limit for Windows Azure Table Storage is below

1. A Table Storage entity is max 1MB
2. A Winodws Azure Account can store max 100TB( Total of Table, Blob and Blob)

 

Answer 2

Hi Ashish,

To answer your question, the only way you can find the total number of rows in your Azure table is by listing all entities. There is no in built "Count()" like functionality in Azure Table Storage.

As far as your other question about the limit of Windows Azure Table Storage, I believe it is up to the size of your storage account.

Hope this helps.

Thanks

Gaurav Mantri

Cerebrata Software

http://www.cerebrata.com

Answer 3

Hi Ashish,

Gaurav is correct regarding the Count() support.

You can make your feelings known here: http://www.mygreatwindowsazureidea.com/forums/34192-windows-azure-feature-voting/suggestions/415607-add-tablestorage-linq-query-support-for-select-co?ref=title

Thanks

Andy