Add Support for Lists/Arrays in Azure Tables
Azure tables need an option to support lists/arrays for per entity instance.
Both Google App Engine (http://code.google.com/appengine/docs/python/datastore/typesandpropertyclasses.html#ListProperty) and Amazon's simpledb both already offer this.
It enables an effective way to relate entities without the over head of traditional SQL.
2 comments
-
Blaz Lipuscek commented
This is really important. The problem is not in serialization of array, you should be able to include condition to scan arrays when performing query. Google does this wonderfully.
-
James Andrews commented
It would be nice if this happened automatically, however I haven't found it too challenging to implement custom WritingEntity event that can convert arrays / lists / dictionaries into Json or byte arrays.
There is an example of how to use the Writing / Reading entity events for all properties on the forums:
http://social.msdn.microsoft.com/Forums/en-US/windowsazure/thread/f57cb566-cc7a-4b31-b1ab-47b6d16604af/Thanks
James