如何使用 LINQ 查询 XML 文档？

Question

假设我有以下 XML 文档：

<response>
   <businessEntity>
      <ABN>
         <identifierValue></identifierValue> 
         <isCurrentIndicator></isCurrentIndicator> 
         <replacedIdentifierValue xsi:nil="true" /> 
         <replacedFrom></replacedFrom> 
      </ABN>
      <entityStatus>
         <entityStatusCode> </entityStatusCode> 
         <effectiveFrom></effectiveFrom> 
         <effectiveTo></effectiveTo> 
      </entityStatus>
      <entityType>
         <entityTypeCode> </entityTypeCode> 
         <entityDescription> </entityDescription> 
      </entityType>
      <goodsAndServicesTax>
          <effectiveFrom></effectiveFrom> 
          <effectiveTo></effectiveTo> 
      </goodsAndServicesTax>
      <legalName>
          <givenName> </givenName> 
          <otherGivenName /> 
          <familyName> </familyName> 
          <effectiveFrom></effectiveFrom> 
          <effectiveTo></effectiveTo> 
      </legalName>
      <mainBusinessPhysicalAddress>
          <stateCode> </stateCode> 
          <postcode></postcode> 
          <effectiveFrom></effectiveFrom> 
          <effectiveTo></effectiveTo> 
      </mainBusinessPhysicalAddress>
   </businessEntity>
</response>

例如，如果我想获取给定名称和家庭名称，我可以这样做：

var businesses = doc.Descendants(ns + "businessEntity")
             .Elements(ns + "legalName")
             .Select(node => new
             {
                 effectiveFrom = node.Element(ns + "effectiveFrom").Value,
                 givenName = node.Element(ns + "givenName").Value,
                 familyName = node.Element(ns + "familyName").Value,
             }).ToList();

然后我可以访问并填充表格，但我不确定如何查询整个文档并获取所有内容我想要的节点，例如 ABN 和实体类型。我是否需要创建一个列表并将每个同级的部分代码复制到 legalName？

提前致谢。

Answer 1

如果您可以假设每个子元素仅出现一次，则可以尝试此方法：

var businesses = (
    from node in doc.Descendants(ns + "businessEntity")
    let legalName = node.Element(ns + "legalName")
    let abn = node.Element(ns + "ABN")
    // etc...
    select new
    {
        LegalName = new
        {
            EffectiveFrom = (string)legalName.Element(ns + "effectiveFrom"),
            GivenName = (string)legalName.Element(ns + "givenName"),
            FamilyName = (string)legalName.Element(ns + "familyName"),
        },
        Abn = new
        {
            IdentifierValue = (string)abn.Element(ns + "identifierValue"),
            IsCurrentIndicator = (string)abn.Element(ns + "isCurrentIndicator"),
            ReplacedFrom = (string)abn.Element(ns + "replacedFrom"),
        },
        // etc...
    }).ToList();


Console.WriteLine(businesses[0].LegalName.GivenName);
Console.WriteLine(businesses[0].Abn.IsCurrentIndicator);

如果要在解析 XML 的方法之外使用此数据，您可能还需要考虑使用具体类型而不是匿名类型。