Reading an XML Element using LINQ

Question

I am trying to read a value from an XML file using LINQ. This is really the first time that I am trying to use LINQ vs. the ordinary C#/.Net approach.

My XML looks like this:

<Description>
<Account Green="A" White="D">House</Account>
<Account Green="B" White="D">Car</Account>
</Description>

This is the LINQexpression I am using. I'd like to read the value House, in other words, the element with the attribute A and D.

var feeds = (from item in doc.Descendants("Description")
 from category in item.Elements("Account")                    
 let attribute = category.Attribute("Green")                    
 let xAttribute = category.Attribute("White")                    
 where attribute != null && (xAttribute != null && (xAttribute.Value == "A" 
 && attribute.Value == "D")) select item.Value).ToString();

I can't figure out what I am doing wrong. Any help is appreciated.

Is it XmlElement or XElement?

user746461
– user746461

2017-03-13 23:22:07 +00:00
Commented Mar 13, 2017 at 23:22 — user746461
– user746461, Commented Mar 13, 2017 at 23:22

BrokenGlass · Accepted Answer · 2012-04-27 21:22:40Z

1

You have an IEnumerable<string> here - you apparently just want a single string here so add a First() to get the value of the first item in your enumeration:

var feeds = (from item in doc.Descendants("Description")
 from category in item.Elements("Account")                    
 let attribute = category.Attribute("Green")                    
 let xAttribute = category.Attribute("White")                    
 where attribute != null && (xAttribute != null && (xAttribute.Value == "A" 
 && attribute.Value == "D")) select category.Value).First();

An easier way to achieve the same might be:

string result = doc.Descendants("Account")
                   .Where(x => x.Attribute("Green") != null && x.Attribute("Green").Value == "A"
                            && x.Attribute("White") != null && x.Attribute("White").Value == "D")
                   .Select(x => x.Value)
                   .First();

edited Apr 27, 2012 at 21:22

answered Apr 27, 2012 at 21:14

BrokenGlass

161k28 gold badges297 silver badges339 bronze badges

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

2 Comments

user1017102 Over a year ago

But this gives me GreenWhite. Just as before.

BrokenGlass Over a year ago

@user1017102: Fixed - need to select category.Value and not item.Value

Collectives™ on Stack Overflow

Reading an XML Element using LINQ

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