How can we improve Azure Storage?

Add TableStorage LINQ query support for Select, Count and Contains

Critical functions such as Select, Count and Contains are not currently available when querying TableStorage data.

If I only want a total number of rows that match a certain criteria I have no choice but to retrieve the data, count it and throw it away.

Adding support for Select would also help with heavy queries by only returning the data selected from a query.

Contains would be useful for searching. Using the Compare function is annoying.

1,082 votes
Sign in
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    JasonJason shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
    Brian VanBrian Van shared a merged idea: Table Storage: Regex $filter  ·   · 
    DennisDennis shared a merged idea: Make LINQ-to-TableStorage  ·   · 

    Thanks for the request! We have delivered support for projection (select), which you can read about at (along with two extra Update options), allowing you to specify which properties you want included when querying tables. The other features requests are under review.


    Sign in
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      • JasonJason commented  ·   ·  Flag as inappropriate

        So... 4 years later. Where are we with Count, Distinct, Contains? Has there been any news at all about Table Storage lately?

      • mikestumikestu commented  ·   ·  Flag as inappropriate

        Somehow I ended up back here while searching for using count with linq, and forgot that it wasn't supported. I also see nobody from Microsoft has replied since my last comment in August...great.

      • MichaelMichael commented  ·   ·  Flag as inappropriate

        Please add sorting/orderby to this list as well. I didn't know table storage was so limited until I started trying to do something with it. :(

      • James ReateguiJames Reategui commented  ·   ·  Flag as inappropriate

        I would either discontinue the Table Storage because it gives the overall product a bad rep, OR make the improvements.
        I know it would cannibalize some of the more expensive SQL Azure sales, if they added too many more LINQ features.

      • Jamison MorrowJamison Morrow commented  ·   ·  Flag as inappropriate

        Thanks to basic limitations like these, I'm having the worst time finding a use case for Azure tables that doesn't multiply my dev time, performance, and total lines of code by a factor of 5. I've given them a chance more than once. I've discovered I like the "idea" of Azure tables far more than the actual implementation. I've been forced to revert to SQL Azure each time out of necessity.

      • JasonJason commented  ·   ·  Flag as inappropriate

        Still waiting for this feature guys! It's been over 2 years now. :) I'm specifically waiting for the ability to perform Counts.

      • AzureAzure commented  ·   ·  Flag as inappropriate

        Select was provided back in Sept 2011, so there has been some progress

      • ZodZod commented  ·   ·  Flag as inappropriate

        Is this ever going to be implemented. It seems like the table storage development has stopped on Azure. It has been 2 years since this was suggested. Also same for Text search on table storage. Can we at least get a "NEVER GONNA HAPPEN" so we can quit holding out hope?

      • EdwinEdwin commented  ·   ·  Flag as inappropriate


        Need atleast orderby based on column for top operator. The current set are like iron age API's. Please understand the developor challenges.


      • Piotr JustynaPiotr Justyna commented  ·   ·  Flag as inappropriate

        Please add "Contains" functionality to the Table Storage as this is critical for filtering data (and this is apparently the purpose of the Table Storage). I'm currently using Azure toolkit for iOS so I was kind of prepared that it will not be implemented out of the box as this is quite new product, but I was very surprised when I discovered that String.Contains() is not supported within my Worker Role project. Are you seriously not planning to implement it yet? It has been requested a year ago. I had (and still have) high hopes for Windows Azure, but you have to try harder to attract new developers to this interesting platform.

      • ValentinValentin commented  ·   ·  Flag as inappropriate

        After 3 days fights with Azure no MORE!
        day 1.Stupid support from India where someone instead answer to me on my simple questions start reading some help files.... Most incompetent support I never see in my live.
        day 2. Reading documentation building application....
        uploading data into storage tables very slow....
        Day 3
        everything was perfect and working until I try to write a function count Row_Numers from table....
        After 20 years developing with MS this is my worst day!
        Why I should pay for some support from India when these people are useless?
        Why I need to pay for some virtual hosting 4 times more expensive since I can get 120$ for dedicated server with 10TB bandwidth?
        for 800$ unmetered 100Mb line?
        Why I should work fulltime and back at home and continue to work for my private business and pay salaries to some TWITTERS from Microsoft who have no clue of this business!
        Good luck to everyone
        The fight ends here for me. I am very disapointed!

      ← Previous 1

      Feedback and Knowledge Base