Best way to query XML in C# - using LINQ, etc

Question

I have an xml message that I need to parse (No control of format) that looks something like the below (Name / Value Pairs) that I need to process. What would be the best method for querying the values out where Name = x and Get the related Value?

I am currently using a nested select to try and get the value out of a specific Name / Value pair. Just wondering if an easier LINQ / Lambda call I could use instead.

Any suggestions would be appreciated.

<Message>
<MessageContent>
  <MessageDetails>
    <Name>System_ID</Name>
    <Value>12345</Value>
  </MessageDetails>
  <MessageDetails>
    <Name>System_Name</Name>
    <Value>Test System</Value>
  </MessageDetails>
</MessageContent>
</Message>

BrokenGlass · Accepted Answer · 2012-02-07 02:38:30Z

7

Use Linq to XML:

var xml = XElement.Load(someXmlFile);
var results = xml.Descendants("MessageDetails")
                 .Where(m => m.Element("Name").Value == someValue)
                 .Select(m => m.Element("Value").Value);

If you expect only one match add a FirstOrDefault() to get the first matching value.

Judging by your xml it looks like you could also benefit from projecting to a dictionary (if your Name element values are unique):

var dictionary = xml.Descendants("MessageDetails")
                    .ToDictionary(x => x.Element("Name").Value, 
                                  x => x.Element("Value").Value);

Now you can just use the dictionary:

string value = dictionary["System_ID"];

edited Feb 7, 2012 at 2:38

answered Feb 7, 2012 at 2:33

BrokenGlass

161k28 gold badges297 silver badges339 bronze badges

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

2 Comments

dtb Over a year ago

Why does every single answer on StackOverflow that uses LINQ-to-XML involve .Descendants? Why recursively search the whole document for the elements when they're known to be the children of the root element? Just wondering...

BrokenGlass Over a year ago

@dtb: That's a fair criticism - it's easier/shorter to prototype and makes less assumptions about your xml structure but for large xml documents it would make a difference

Val Akkapeddi · Accepted Answer · 2012-02-07 02:43:22Z

-1

If you have no control of the format, and it's likely to change in the future, I'd consider using XPath as well, so you can modify your selects with fewer code-changes. For example, the XPath to get System ID would be:

//MessageContent/MessageDetails[Name='System_Name']/Value

answered Feb 7, 2012 at 2:43

Val Akkapeddi

1,18310 silver badges17 bronze badges

Collectives™ on Stack Overflow

Best way to query XML in C# - using LINQ, etc

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related