LINQ: Remove Element from XML based on attribute value?

Question

How can I remove any element in xml based on matched attribute value?

Here is my XML :

<Projects>
    <Project serverUrl="tcp://xyz1:xxx/sdfsdf.rem" projectName="project1" />
    <Project serverUrl="tcp://xyz2:xxx/sdfsdf.rem" projectName="project2" />
    <Project serverUrl="tcp://xyz3:xxx/sdfsdf.rem" projectName="project3" />
    <Project serverUrl="tcp://xyz4:xxx/sdfsdf.rem" projectName="project4" />
    <Project serverUrl="tcp://xyz5:xxx/sdfsdf.rem" projectName="project5" />
    <Project serverUrl="tcp://xyz6:xxx/sdfsdf.rem" projectName="project6" />
   </Projects>

I am using the following LINQ query:

var remove = from elemet in xdoc.Elements("Projects").Elements("Project")
                                 where elemet.Attribute("projectName").Value == "project1"
                                 select elemet.Parent.Remove();

I am getting compile time error on select as :

The type of expression in select clause is Incorrect

EDIT ANSWER: this one works for me. Thanks All

var xElement = (from elemet in xdoc.Elements("Projects").Elements("Project")
                            where elemet.Attribute("projectName").Value == foundProject
                            select elemet);
            xElement.Remove();

Heinzi · Accepted Answer · 2011-02-15 14:02:53Z

10

Remove is a (void) method call, not a function that can return a value. You probably want something like this:

var elementsToRemove = from elemet in xdoc.Elements("Projects").Elements("Project")
                       where elemet.Attribute("projectName").Value == "project1"
                       select elemet;

foreach (var e in elementsToRemove)
    e.Remove();

LINQ is a query language, it's (mainly) used to return something. Performing actions on these elements is usually a separate step.

answered Feb 15, 2011 at 14:02

Heinzi

173k61 gold badges386 silver badges554 bronze badges

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

Comments

Bala R · Accepted Answer · 2011-02-15 14:02:42Z

7

You could use

xdoc.Elements("Projects").Elements("Project").Where(
                    elemet => elemet.Attribute("projectName").Value == "project1")
.ToList().ForEach(i => i.Remove());

or

(from elemet in xdoc.Elements("Projects").Elements("Project")
                          where elemet.Attribute("projectName").Value == "project1"
                          select elemet).ToList().ForEach(i => i.Remove());

answered Feb 15, 2011 at 14:02

Bala R

109k23 gold badges203 silver badges212 bronze badges

Comments

Igor Korkhov · Accepted Answer · 2011-02-15 14:00:48Z

4

You can use the following code snippet:

xdoc.XPathSelectElement("Projects/Project[@projectName = 'project1']").Remove();

answered Feb 15, 2011 at 14:00

Igor Korkhov

8,7201 gold badge28 silver badges32 bronze badges

Comments

Ocelot20 · Accepted Answer · 2011-02-15 14:00:49Z

1

Remove() is a method you call on an XNode. Your query is trying to select the method which doesn't make any sense.

What you actually want to do is select the item you wish to remove, then call the Remove() method on the selected item. You can find an example here: XNode.Remove Method

answered Feb 15, 2011 at 14:00

Ocelot20

10.8k11 gold badges57 silver badges98 bronze badges

Collectives™ on Stack Overflow

LINQ: Remove Element from XML based on attribute value?

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related