Agreed. Perhaps if the ability to use LINQ's Contains was permitted then you could get around the multiple single queries. You could basically perform a "where RowKey in (1,6,20,55)" sort of query. But that only solves half the problem.

Upsert is definitely a must!

Yes, please add Count!

Perhaps my suggestion is a duplicate of this but I'm not sure -

http://www.mygreatwindowsazureidea.com/pages/34192-windows-azure-feature-voting/suggestions/415607-add-tablestorage-linq-query-support-for-select-count-and-contains?ref=title

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

Contains would also be VERY useful when trying to perform queries similar to 'Where ID in (1,5,10)' which is not possible right now.

Support for DISTINCT is also needed!