tags:

views:

19

answers:

1
Q: 

Retrieve All Elements as a list - LINQ to XML

Hello, I am trying to query an XML file. Below query returns the first element in the sequence. Wondering how to get all elements in the sequence as a List. rsltQuest is of type List of XElement.

 
rsltQuest = doc1.Descendants(xmlns + "QUESTION")
                                 .Where(t => t.Attribute("ANSWER").Value == "no").ToList();`

Thanks for your advices. M

A: 

I see two issues but both should not cause the result to be a one element list (provided there are more than one QUESTION elements having an ANSWER attribute with value "no"):

  • You close one more parenthesis than you open.
  • You could get a null pointer exception if there is an QUESTION element having no ANSWER attribute.

So, are you sure the data contains more than one QUESTION with ANSWER="no"? Or maybe this is a namespace issue?

EDIT: Maybe you should try (string)(t.Attribute("ANSWER")) == "no"

Frank  2010-08-18 17:17:03
@Frank Thanks. Parenthesis is a typo. Yes my XML file has more than one QUESTION with ANSER = "no". I am sure it is not an namespace issue.
BumbleBee  2010-08-18 17:30:56
Then you would have to narrow it down: What is the result from just `doc1.Descendants(xmlns + "QUESTION")`?
Frank  2010-08-18 17:42:01
gives me all the QUESTION elements in the doc1
BumbleBee  2010-08-18 17:48:33
So the issue must be in the Where() or the ToList() (or your check of the result. I just would try these systematically to narrow the area of the failure: If you add the Where, is the result still as expected? If yes, if you add the ToList()?
Frank  2010-08-18 17:53:30

related questions

Merge XML files in a XDocument
LINQ to XML optional element query
convert XmlNode to XNode?
Validating and Extracting XML record by record into Database
Save attribute value of xml element with single quotes using linq to xml.
Linq to XML 'Where not in' syntax problem
How can I combine this code into one or two LINQ queries?
How do I do a deep copy of an element in LINQ to XML?
How do I access the XML data in my column using LINQ to XML?
How can I extract specific tags using linq to xml in F# ?
How do you handle arbitrary namespaces when querying over Linq to XML?
LINQ to XML gets no data with schema set
Is there a way to retrieve elements using only local names in a Linq-to-XML query?
How to get the position() of an XElement?
How to get Single XElement object using Linq to Xml ?
LINQ to XML for a small appliction can it replace a small database?
Issue with XDocument and the BOM (Byte Order Mark)
I need a LINQ expression to find an XElement where the element name and attributes match an input node.
How can I get an XElement's innertext in Linq to XML?
Linq to XML for KML?
LINQ to XML Newbie Question: Returning More Than One Result
LINQ to XML Newbie Question
Do namespaces propagate to children in XElement objects?
How can I extract a part of a xaml object graph via linq to xml?
IntelliSense for XElement objects with XML schema