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.
4 comments
-
W.M.
commented
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.
-
Dennis
commented
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 Kelly
commented
Would also be nice to support the OrderBy LINQ clause when returning rows.
-
Dennis
commented
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.