Using List<string> with Azure Table Storage

.net list azure azure-storage
Alan Grixti picture Alan Grixti · Mar 21, 2013 · Viewed 8.6k times · Source

I am currently making use of the Windows Azure Table Storage Mechanism, having a class which extends TableEntity. However, one of the fields of this class is a List. When getting the entity back from the table, it is returned as a DynamicTableEntity rather than a normal Table Entity. Is there a way to obtain the list from the table rather than serializing the list and storing it on a blob?

Answer

Stopped Contributing picture Stopped Contributing · Mar 21, 2013

As you may already know, complex data types are not natively supported by Azure Table Storage. For a list of supported data types, please see here: http://msdn.microsoft.com/en-us/library/windowsazure/dd179338.aspx.

One option is to serialize this List into a delimited string as you mentioned.

Other option is to use a 3rd party library like Lucifure Stash (http://lucifurestash.codeplex.com/). I haven't used it myself but the documentation states that you could store arrays and lists as entity in Azure Tables.

Related questions

Using LINQ to remove elements from a List<T>

Say that I have LINQ query such as: var authors = from x in authorsList where x.firstname == "Bob" select x; Given that authorsList is of type List<Author>, how can I delete the Author elements from authorsList that …

Read More
Check if list contains element that contains a string and get that element

While searching for an answer to this question, I've run into similar ones utilizing LINQ but I haven't been able to fully understand them (and thus, implement them), as I'm not familiarized with it. What I would like to, basically, …

Read More
Merge two (or more) lists into one, in C# .NET

Is it possible to convert two or more lists into one single list, in .NET using C#? For example, public static List<Product> GetAllProducts(int categoryId){ .... } . . . var productCollection1 = GetAllProducts(CategoryId1); var productCollection2 = GetAllProducts(CategoryId2); var productCollection3 = GetAllProducts(CategoryId3);

Read More