JSON属性的相应XML是什么？

Question

我有一个JSON属性，需要将其插入Oracle DB中。我正在尝试在C＃中制作XML节点，然后通过ExtractValue XML序列概念在Oracle中插入。

name 属性以几种语言配置

"name": {
                "en-US": {
                    "1": "name in english1",
                    "3": "name in english2"
                },
                "ar-SA": {
                    "2": "name in arabic1"
                }
        }

。有人告诉上述属性XML应该是什么样的？

Answer 1

无论您想要什么。

选项1：

<name>
  <en-US object-number="1">name in english1</en-US>
  <en-US object-number="3">name in english2</en-US>
  <ar-SA object-number="2">name in arabic1</ar-SA>
</name>

选项2：

<name>
  <language value="en-US">
    <object-number value="1">name in english1</object-number>
    <object-number value="3">name in english2</object-number>
  </language>
  <language value="ar-SA">
    <object-number value="2">name in arabic1</object-number>
  </language>
</name>

选项3：

<names>
  <name>
    <language>en-US</language>
    <object-number>1</object-number>
    <value>name in english1</value>
  </name>
  <name>
    <language>en-US</language>
    <object-number>3</object-number>
    <value>name in english2</value>
  </name>
  <name>
    <language>ar-SA</language>
    <object-number>2</object-number>
    <value>name in arabic1</value>
  </name>
</names>

选项4：

<names>
  <name language="en-US" object-number="1">name in english1</name>
  <name language="en-US" object-number="3">name in english2</name>
  <name language="ar-SA" object-number="2">name in arabic1</name>
</names>

您可以使用更多的品种。