Linq to XML - Select multiple elements

Question

I have one xml file with a collection of cars. I want to remove a element A and B if the car is green :

<?xml version="1.0" encoding="utf-8" standalone="no"?>
<Cars>
    <Car>
        <Color>Green</Color>
        <A>Value</A>
        <B>Value</B>
    </Car>
    <Car>
        <Color>Blue</Color>
        <A>Value</A>
        <B>Value</B>
    </Car>
    <Car>
        <Color>Yellow</Color>
        <A>Value</A>
        <B>Value</B>
    </Car>
</Cars>

I do :

XDocument.Root.Descendants("Car").Where(x => x.Element("Color").Value == "Green"). Select(x => x.Element("A")).Remove();

XDocument.Root.Descendants("Car").Where(x => x.Element("Color").Value == "Green"). Select(x => x.Element("B")).Remove();

It's work but how to do this in one line ? How to select two elements in Select ?

Thank's

Sample xml data and expected output would be helpful. The only way to achieve that is to projecting only these elements you want to get as an output. — Maciej Los
– Maciej Los, Commented Jul 6, 2016 at 8:01

har07 · Accepted Answer · 2016-07-07 23:28:31Z

2

This is one possible way, find Color element where value equals 'Green', grab all the following sibling elements using ElementsAfterSelf(), flatten them using SelectMany(), and finally remove them :

XDocument.Root
         .Descendants("Car")
         .Elements("Color")
         .Where(c => c.Value == "Green")
         .SelectMany(c => c.ElementsAfterSelf())
         .Remove();

UPDATE :

If the target elements strictly need to be identified by name e.g not necessarily all elements after <Color>, you can use Where() method as follow :

XDocument.Root
         .Descendants("Car")
         .Where(c => (string)c.Element("Color") == "Green")
         .SelectMany(c => c.Elements()
                           .Where(e => e.Name.LocalName == "A" ||
                                       e.Name.LocalName == "B"))
         .Remove();

If list of target element names may grow to more than 2 ("A" and "B"), I'd suggest to use array and Contains() for filtering :

var targetElementNames = new[]{ "A", "B", "C" };
XDocument.Root
         .Descendants("Car")
         .Where(c => (string)c.Element("Color") == "Green")
         .SelectMany(c => c.Elements()
                           .Where(e => targetElementNames.Contains(e.Name.LocalName))
         .Remove();

edited Jul 7, 2016 at 23:28

answered Jul 6, 2016 at 9:14

har07

89.5k12 gold badges87 silver badges143 bronze badges

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

2 Comments

Maciej Los Over a year ago

Great! I hope that it's exactly what OP needs, because i'm pretty sure he wants to get only Car nodes which Color is green and return list of Car nodes that contain only Color subnode.

user6313890 Over a year ago

Yes but I want not remove all elements after self

Collectives™ on Stack Overflow

Linq to XML - Select multiple elements

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related