How can we improve Windows Azure Data Management: Tables?

Make LINQ-to-TableStorage

The table storage entities are nice, but need more power. This should support secondary indexes (when those are added) and also partitions with mixed schema rows.

130 votes
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    DennisDennis shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    4 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...
      • W.M.W.M. commented  ·   ·  Flag as inappropriate

        This goes along with full text search, the ability to reduce entity sets based on a textual LINQ query server side would speed up apps and reduce costs for customers.

      • DennisDennis commented  ·   ·  Flag as inappropriate

        Now that I've seen the way CouchDB implements Map and Reduce functions, I would prefer having the ability to create those functions within Table Storage over what I was thinking when I posed this suggestion.

      • Mike KellyMike Kelly commented  ·   ·  Flag as inappropriate

        Would also be nice to support the OrderBy LINQ clause when returning rows.

      • DennisDennis commented  ·   ·  Flag as inappropriate

        Because partitions are within a single table and each table can have heterogeneous rows, it should be possible to simulate one-to-many and even many-to-many relationships between rows of a single table. I'm looking for an easy way to set that up.

        Transactions are also limited to a single partition within a single table, so I'm also hoping that there would be support for creating master and detail rows within a table/partition and update them all within a transaction.

      Feedback and Knowledge Base