How to save binary to Azure Table Storage by TableServiceEntity?

Question

If I want to save binary to Azure Table, when I create a class inherited by TableServiceEntity, whats the datatype should I use? and how to check the length for the datatype to insure its not over 64k

public class SomeEntity : TableServiceEntity
{
      public whattype BinaryData { get; set; }
}

For binary data I tend to put it in a Blobstore and then a reference to that in my table. — onnoweb
– onnoweb, Commented Mar 26, 2012 at 20:43
I like to query them in one transaction, since I always need them both and binary is less than 64k — Eric Yin
– Eric Yin, Commented Mar 26, 2012 at 20:52
You could also check the FatEntities by LokadCloud - code.google.com/p/lokad-cloud/wiki/FatEntities It might suit your needs the best! — astaykov
– astaykov, Commented Mar 27, 2012 at 5:42

hocho · Accepted Answer · 2012-12-28 18:06:14Z

4

For binary, a byte[] of length <= 64K is all that is necessary. The table storage client will convert it into Base64 for transport purposes only but storage will be in binary. If you want to store more than 64K you can split it across multiple columns.

I have written an alternate Azure table storage client, Lucifure Stash, which supports large data columns > 64K, arrays, enums, serialization, public and private properties and fields and more. It is open sourced and available at http://lucifurestash.codeplex.com and via NuGet.

edited Dec 28, 2012 at 18:06

answered Mar 26, 2012 at 21:01

hocho

1,7491 gold badge11 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Eric Yin Over a year ago

Interesting, will go check. Can it support more than 1M data in one row?

hocho Over a year ago

Azure table storage does not support more than 1MB total row size. This includes overheads, including space used for storing the property names. Of course you can use a level of abstraction and split across multiple rows but Blob storage would be the preferred implementation here.

Collectives™ on Stack Overflow

How to save binary to Azure Table Storage by TableServiceEntity?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related