如何使用 LINQ 选择内部 XML 节点的集合？

发布于 2024-10-20 03:07:50 字数 918 浏览 1 评论 0原文

我有以下 xml。给定 UID、制造商名称和图像布局，我想提取 xml 中存在的所有可能尺寸。

<Rules>
  <UniqueID UID="123413">
    <Manufacturer Name="XYZ Company">
      <Image Layout="Portrait">
        <Size rows="512" cols="512" price="x" />
        <Size rows="1024" cols="1024" price="y" />
      </Image>
    </Manufacturer>
  </UniqueID>
</Rules>

我现在的做法是：

XElement rules = XElement.Parse(xmlDoc.OuterXml);

var uids = rules.Elements("UniqueID")
                .Where(x=> (string)x.Attribute("UID")=="123413")
                .ToList();

foreach(var uid in uids)
{
    var manufacturers = uid.Elements(("UniqueID")
                           .Where(x=> (string)x.Attribute("Name")=="XYZ Company")
                           .ToList();
}

依此类推，直到我收集了可能的尺寸。

所以我使用了 3 个 foreach 循环。有没有更好的方法使用 LINQ 通过一行代码来实现此目的？

原文

I have the following xml. Given, a UID, Manufacturer Name and Image Layout, I want to pull out all possible sizes that exist in the xml.

<Rules>
  <UniqueID UID="123413">
    <Manufacturer Name="XYZ Company">
      <Image Layout="Portrait">
        <Size rows="512" cols="512" price="x" />
        <Size rows="1024" cols="1024" price="y" />
      </Image>
    </Manufacturer>
  </UniqueID>
</Rules>

The way i do it right now is:

XElement rules = XElement.Parse(xmlDoc.OuterXml);

var uids = rules.Elements("UniqueID")
                .Where(x=> (string)x.Attribute("UID")=="123413")
                .ToList();

foreach(var uid in uids)
{
    var manufacturers = uid.Elements(("UniqueID")
                           .Where(x=> (string)x.Attribute("Name")=="XYZ Company")
                           .ToList();
}

and so on until I have a collection of the possible sizes.

So I am using 3 foreach loops. Is there a better way acheive this with probably one line of code, using LINQ?

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

殊姿 2024-10-27 03:07:50

虽然有点拗口，但您可以使用 XPathSelectElements：

 var sizes = rules.XPathSelectElements("//UniqueId[@UID = '123413']/Manufacturer[@Name = 'XYZ Company']//Size");

显然，您可以使用字符串格式来动态插入 @UID 和 @Name 的值。

确保包含 System.Xml.XPath。

It's a little bit of a mouthful, but you can use XPathSelectElements:

 var sizes = rules.XPathSelectElements("//UniqueId[@UID = '123413']/Manufacturer[@Name = 'XYZ Company']//Size");

Obviously, you could use string formatting to dynamically insert values for @UID and @Name.

Make sure to include System.Xml.XPath.

回复收藏 0 原文

ぃ弥猫深巷。 2024-10-27 03:07:50

我喜欢 James 的 XPath 方法。如果您继续堆叠 LINQ，它可能会是什么样子。

var sizes = xmlDoc.Elements("Rules")
    .Elements("UniqueID")
    .Where(e => e.Attribute("UID").Value=="123413")
    .Elements("Manufacturer")
    .Where(e => e.Attribute("Name").Value=="XYZ Company")
    .Elements("Image")
    .Where(e => e.Attribute("Layout").Value=="Portrait")
    .Elements("Size");

sizes 最终成为 IEnumerable（2 项）

<Size rows="512" cols="512" price="x" />
<Size rows="1024" cols="1024" price="y" />

I like James's XPath approach. Here is what it might look like if you just keep stacking LINQ.

var sizes = xmlDoc.Elements("Rules")
    .Elements("UniqueID")
    .Where(e => e.Attribute("UID").Value=="123413")
    .Elements("Manufacturer")
    .Where(e => e.Attribute("Name").Value=="XYZ Company")
    .Elements("Image")
    .Where(e => e.Attribute("Layout").Value=="Portrait")
    .Elements("Size");

sizes ends up being IEnumerable (2 items)

<Size rows="512" cols="512" price="x" />
<Size rows="1024" cols="1024" price="y" />

回复收藏 0 原文

扬花落满肩 2024-10-27 03:07:50

试试这个（使用 XPath）：

String xmlString = @"<Rules> <UniqueID UID=""123413""> <Manufacturer Name=""XYZ Company""> <Image Layout=""Portrait""> <Size rows=""512"" cols=""512"" price=""x"" /> <Size rows=""1024"" cols=""1024"" price=""y"" /> </Image> </Manufacturer> </UniqueID> </Rules>";
XElement element = XElement.Parse(xmlString);

var uids = element.XPathSelectElements("//UniqueID[@UID=123413]/Manufacturer[@Name='XYZ Company']/Image[@Layout='Portrait']/Size")
          .Select(a=> new {rows=a.Attribute("rows").Value, cols=a.Attribute("cols").Value})
        .ToList();  
foreach(var uid in uids) 
{     
    Console.WriteLine(uid.rows + " - " + uid.cols);
}

Try this(used XPath):

String xmlString = @"<Rules> <UniqueID UID=""123413""> <Manufacturer Name=""XYZ Company""> <Image Layout=""Portrait""> <Size rows=""512"" cols=""512"" price=""x"" /> <Size rows=""1024"" cols=""1024"" price=""y"" /> </Image> </Manufacturer> </UniqueID> </Rules>";
XElement element = XElement.Parse(xmlString);

var uids = element.XPathSelectElements("//UniqueID[@UID=123413]/Manufacturer[@Name='XYZ Company']/Image[@Layout='Portrait']/Size")
          .Select(a=> new {rows=a.Attribute("rows").Value, cols=a.Attribute("cols").Value})
        .ToList();  
foreach(var uid in uids) 
{     
    Console.WriteLine(uid.rows + " - " + uid.cols);
}

回复收藏 0 原文

~没有更多了~