LINQ to XML Select Nodes based on child node and attribute

Question

I am just moving over to LINQ, so still get stuck with certain scenarios.

In the following XML I need to select the correct Persist node based on the RoomCodes attribute value and also grab need the other values from the Item/@attributes based on what we selected. So if I needed the second one I would select by the @RoomCodes = "257|1" and would also need the currency etc. from that Persist node.

Thanks All

Daz

<Root>
    <Persist>
        <Item SequenceNum="Wy4FDfktUFj"/>
        <Item RatePlanCode="Qgcu8UofK+ARXUwDD6NGf"/>
        <Item RoomCodes="232|4"/>
        <Item AmountAfterTax="1442.00"/>
        <Item CurrencyCode="USD"/>
    </Persist>
    <Persist>
        <Item SequenceNum="Wy4FDfktUFj"/>
        <Item RatePlanCode="Unk28iUoIjundujak+9094j3"/>
        <Item RoomCodes="257|1"/>
        <Item AmountAfterTax="552.00"/>
        <Item CurrencyCode="USD"/>
    </Persist>
</Root>

Sergey Berezovskiy · Accepted Answer · 2013-07-16 13:47:11Z

2

string value = "232|4";
var xdoc = XDocument.Load(path_to_xml);
var persist = 
    xdoc.Root.Elements("Persist")
        .FirstOrDefault(p => 
            p.Elements().Any(i => (string)i.Attribute("RoomCodes") == value));

Or with XPath extensions for LINQ to XML:

var persist = xdoc.XPathSelectElement("//Persist[Item/@RoomCodes='257|1']");

edited Jul 16, 2013 at 13:47

answered Jul 16, 2013 at 13:41

Sergey Berezovskiy

237k44 gold badges441 silver badges468 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

LINQ to XML Select Nodes based on child node and attribute

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related