Retrieve the node values from XML file in LINQ and C#

Question

I have a xml file and I want to retrieve the values from the message attributes into a string array from the below structure:

<Exceptions>
  <Exception Name="Address">
    <Error id="Line1" message="Address Line 1 is required"/>
    <Error id="Line1Length" message="Address Line 1 must be in-between 1 and 50"/>
    <Error id="Line2Length" message="Address Line 2 must be in-between 1 and 50"/>
  </Exception>
  <Exception Name="Email">
    <Error id="Line1" message="Email is required"/>
  </Exception>
</Exceptions>

How can I do this using LINQ-XML?

Which message? All of them? Do you want to concat them all into one string or return an array of all the message strings? — Brad Cunningham
– Brad Cunningham, Commented Dec 6, 2012 at 8:45

Sergey Berezovskiy · Accepted Answer · 2012-12-06 08:58:41Z

6

string id = "Line1Length";
XDocument xdoc = XDocument.Load(path_to_xml);
var messages = xdoc.Descendants("Error")
                   .Where(e => (string)e.Attribute("id") == id)
                   .Select(e => (string)e.Attribute("message"));

Also if you didn't provide full structure of xml file, then:

var messages = xdoc.Descendants("Exceptions")
                   .Element("Exception")
                   .Elements("Error")
                   .Where(e => (string)e.Attribute("id") == id)
                   .Select(e => (string)e.Attribute("message"));

BTW this will return IEnumerable<string> messages. If you want array, then apply ToArray() after select operator.

edited Dec 6, 2012 at 8:58

answered Dec 6, 2012 at 8:46

Sergey Berezovskiy

237k44 gold badges441 silver badges468 bronze badges

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

4 Comments

Vara Prasad.M Over a year ago

How to check this with the "id"?

Sergey Berezovskiy Over a year ago

@VaraPrasad.M updated samples with filtering. If you need single element, than use .SingleOrDefalult() operator

Vara Prasad.M Over a year ago

Now if we got other than "Address" and now i want to retrieve "Email" then how can i get. updated question

Sergey Berezovskiy Over a year ago

@VaraPrasad.M same approach - .Descendants("Exeption").Where(e => (string)e.Attribute("Name") == "Email").Elements("Error")...`

Hamlet Hakobyan · Accepted Answer · 2012-12-06 09:02:41Z

1

Something like this:

string xml = "<Exceptions>
  <Exception Name='Address'>
    <Error id='Line1' message='Address Line 1 is required'/>
    <Error id='Line1Length' message='Address Line 1 must be in-between 1 and 50'/>
    <Error id='Line2Length' message='Address Line 2 must be in-between 1 and 50'/>
  </Exception>
</Exceptions>";

var document = XDocument.Load(new XmlTextReader(xml));
var messages = document.Descendants("Error").Attributes("message").Select(a => a.Value);

edited Dec 6, 2012 at 9:02

answered Dec 6, 2012 at 8:51

Hamlet Hakobyan

33.5k6 gold badges55 silver badges71 bronze badges

Collectives™ on Stack Overflow

Retrieve the node values from XML file in LINQ and C#

2 Answers 2

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related