C# LINQ XML filtering by attribute

Question

I have the following XML:

<PlayerSetup>
    <CardDeck name="deckOfCards"/>
    <Card name="one"/>
    <Card name="two"/>
    <Card name="three"/>
    <Card name="four"/>
    <Token name="four"/>
</PlayerSetup>

I need to retrieve only the elements which attributes name="four", I have the following code:

var query = from d in xdoc.Descendants("PlayerSetup")
             where (string)d.Attribute("name").Value == "four"
             select d;

Which of course, is not working, returns no elements. Any idea ? Thanks.

You mean you want 1) the PlayerSetup elements with a descendant element with attribute name="four"; or 2) the descendant elements of PlayerSetup with attribute name="four"? — dbc
– dbc, Commented Sep 30, 2015 at 20:22
Yes, name is attribute of Card, not PlayerSetup, @Eser thanks for your answer, I was actually close to it but I didn't know that I could use multiple Descendants() to keep "digging" into the xml tree. — Emiliano
– Emiliano, Commented Sep 30, 2015 at 21:53

dbc · Accepted Answer · 2015-09-30 20:28:57Z

2

If you want the descendant elements under the "PlayerSetup" elements with name="four", you can do:

        var query = from d in xdoc.Descendants("PlayerSetup").Descendants()
                    where (string)d.Attribute("name") == "four"
                    select d;

If you want the "PlayerSetup" elements who have at least one descendant element with name="four", you can do:

        var query = from d in xdoc.Descendants("PlayerSetup")
                    where d.Descendants().Any(c => (string)c.Attribute("name") == "four")
                    select d;

answered Sep 30, 2015 at 20:28

dbc

120k27 gold badges273 silver badges404 bronze badges

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

Comments

Jonesopolis · Accepted Answer · 2015-09-30 20:28:32Z

1

You are wanting to look at the Descendants of PlayerSetup, so grab those:

var query = from d in xdoc.Descendants("PlayerSetup").Descendants()
            where d.Attribute("name")?.Value == "four"
            select d;

//query.Count == 2

this solution uses C#6 syntax

answered Sep 30, 2015 at 20:28

Jonesopolis

25.4k12 gold badges72 silver badges115 bronze badges

Comments

Community · Accepted Answer · 2017-05-23 12:22:23Z

-1

I think your problem is already known for a long time.

You can find it here: LINQ to XML query attributes

or here: How to get attribute names of element in xml by LINQ in C#

:)

edited May 23, 2017 at 12:22

CommunityBot

11 silver badge

answered Sep 30, 2015 at 20:33

Borys Rybak

1001 silver badge9 bronze badges

1 Comment

Emiliano Over a year ago

I already saw the first link and didn't work for my example, but thanks

Collectives™ on Stack Overflow

C# LINQ XML filtering by attribute

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related