azure - 如何将数组的内容存储在表存储中

Question

我需要将数组的内容存储到 Azure 表存储中。该数组将包含 0 到 100 个条目。我不想创建 100 个不同的元素，所以有没有办法可以打包数组、存储它并稍后解包。任何例子将不胜感激。我只是不知道从哪里开始:-(

Answer 1

您需要将数组序列化为二进制或xml，然后使用适当的列类型来存储数据(二进制对象或xml。)

XML 将是最灵活的，因为您仍然可以在值存储时查询它们。 (您无法查询二进制数据。无论如何都不容易。)以下是 serializing 的示例这是 inserting the value 的一个放入表格中。

Some detail on XML support in Azure :

The xml Data Type

SQL Azure Database supports xml data type that stores XML data. You can store xml instances in a column or in a variable of the xml type.

Support for XML Data Modification Language

The XML data modification language (XML DML) is an extension of the XQuery language. The XML DML adds the following case-sensitive keywords to XQuery and they are supported in SQL Azure Database:

insert (XML DML) delete (XML DML) replace value of (XML DML)

Support for xml Data Type Methods

You can use the xml data type methods to query an XML instance stored in a variable or column of the xml type. SQL Azure Database supports the following xml data type methods:

query() Method (xml data type) value() Method (xml data type) exist() Method (xml data type) modify() Method (xml data type) nodes() Method (xml data type)