C#；LINQ-在xml查询中获取父元素的名称

本文关键字：元素 获取 LINQ- xml 查询 | 更新日期: 2023-09-27 18:07:10

我有一个XML文件，其中包含IP地址及其分配的位置/楼层，如下所示：

<Locations>
   <LOCATION1>
      <FLOOR1>
         <SECTION1>
            <IP>10.10.10.10</IP>
            <IP>etc....
         </SECTION1>
      </FLOOR1>
   </LOCATION1>
.....

我试图做的是查询IP地址并返回父元素的名称。我可以查询该IP，但我没有弄清楚如何获得父元素名称(即SECTION1、FLOOR1、LOCATION1(。以下是我用于查询xml以查找IP的代码，我只是让它返回当前的值来验证我的查询是否成功：

var query = from t in xmlLocation.Descendants("IP")
            where t.Value.Equals(sIP)
            select t.Value;

C#；LINQ-在xml查询中获取父元素的名称

试试这个：XML

<?xml version="1.0" encoding="utf-8" ?>
<Locations>
  <LOCATION1>
    <FLOOR1>
      <SECTION1>
        <IP>10.10.10.10</IP>
        <IP>20.20.20.20</IP>
      </SECTION1>
    </FLOOR1>
    <FLOOR2>
      <SECTION1>
        <IP>30.30.30.30</IP>
        <IP>40.40.40.40</IP>
      </SECTION1>
    </FLOOR2>
  </LOCATION1>
</Locations >
​

代码

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.IO;
using System.Xml;
using System.Xml.Linq;
namespace ConsoleApplication1
{
    class Program
    {
        const string FILENAME = @"c:'temp'test.xml";
        static void Main(string[] args)
        {
            XDocument doc = XDocument.Load(FILENAME);
            var results = doc.Descendants("LOCATION1").Elements().Select(x => new
            {
                parent = x.Name.ToString(),
                ip = x.Descendants("IP").Select(y => (string)y).ToList()
            }).ToList();
        }
    }
}
​

下面的代码获取位置、楼层和截面

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.IO;
using System.Xml;
using System.Xml.Linq;
namespace ConsoleApplication1
{
    class Program
    {
        const string FILENAME = @"c:'temp'test.xml";
        static void Main(string[] args)
        {
            XDocument doc = XDocument.Load(FILENAME);
            var results = doc.Descendants("Locations").Elements().Select(x => x.Elements().Select(y => y.Elements().Select(z => new {
                location = x.Name.ToString(),
                floor = y.Name.ToString(),
                section = z.Name.ToString(),
                ip = z.Descendants("IP").Select(i => (string)i).ToList()
            })).SelectMany(a => a)).SelectMany(b => b).ToList();
        }
    }
}
​

var xDoc = XDocument.Load(filename);
var ip = xDoc.XPathSelectElement("//IP['10.10.10.10']");
var names = ip.Ancestors().Select(a => a.Name.LocalName).ToList();

名称将包含SECTION1, FLOOR1, LOCATION1, Locations

如果你事先知道这些名称，你也可以使用它们来选择正确的节点

var ip = xDoc.XPathSelectElement("//LOCATION1/FLOOR1/SECTION1/IP['10.10.10.10']");

或

var section = xDoc.XPathSelectElement("//LOCATION1/FLOOR1/SECTION1[IP['10.10.10.10']]");
相关文章：