How to get XML Attribute and Element with One Linq Query?

Question

I have an XML document that looks like this:

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
  <searchlayers>
    <searchlayer whereClause="ProjectNumber=a">Herbicide</searchlayer>
    <searchlayer whereClause="ProjectNumber=b">Herbicide - Point</searchlayer>
    <searchlayer whereClause="ProjectNumber=c">miscellaneous</searchlayer>
    <searchlayer whereClause="ProjectNumber=d">miscellaneous - Point</searchlayer>
    <searchlayer whereClause="ProjectNumber=e">Regrowth Control</searchlayer>
    <searchlayer whereClause="ProjectNumber=f">Regrowth Control - Point</searchlayer>
    <searchlayer whereClause="ProjectNumber=g">Tree Removal</searchlayer>
    <searchlayer whereClause="ProjectNumber=h">Tree Removal - Point</searchlayer>
    <searchlayer whereClause="ProjectNumber=i">Trimming</searchlayer>
    <searchlayer whereClause="ProjectNumber=j">Trimming - Point</searchlayer>
  </searchlayers>
</configuration>

Is it possible to write one single Linq statement to get each of the element (e.g. Herbicide, miscellaneous, Regrowth Control... etc) with its matching whereClause (e.g. for Herbicide, the where clause would be "ProjectNumber=a")?

I can write two statements separately, one to get the elements, one to get the attributes, but it would be nice to write just one Linq statement that gets both at the same time.

Thanks.

har07 · Accepted Answer · 2014-06-02 02:06:18Z

1

Yes it is possible. But there are many possible data structure can be used to store list of 2 values pair, here is one example using Tuple :

XDocument doc = XDocument.Load("path_to_xml_file.xml");
List<Tuple<string, string>> result =
                doc.Root
                   .Descendants("searchlayer")
                   .Select(o => Tuple.Create((string) o, (string) o.Attribute("whereClause")))
                   .ToList();

answered Jun 2, 2014 at 2:06

har07

89.5k12 gold badges87 silver badges143 bronze badges

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

Comments

Baldrick · Accepted Answer · 2014-06-02 02:04:12Z

0

You can create a set of anonymous objects as follows:

var result = root.Element("searchlayers")
                 .Elements("searchlayer")
                 .Select(i => 
                     new {attribute = i.Attribute("whereClause").Value, 
                          value = i.Value});

This will give a set of records, where the attributes are paired with the element values.

If you want this in query syntax, it looks like this:

var result = from el in root.Elements("searchlayers").Elements("searchlayer")
             select new {attribute = el.Attribute("whereClause").Value, 
                         value = el.Value};

answered Jun 2, 2014 at 2:04

Baldrick

11.9k2 gold badges34 silver badges37 bronze badges

Comments

Johnathon Sullinger · Accepted Answer · 2014-06-02 02:06:10Z

0

You can use this to to select all elements matching Herbicide whose whereClause matches ProjectNumber=a

IEnumerable<XElement> result =
    from el in doc.Elements("Herbicide")
    where (string)el.Attribute("whereClause") == "ProjectNumber=a"
    select el;

Another alternative would be:

var result = doc.Descendants()
        .Where(e => e.Attribute("ProjectNumber=a") != null)
        .ToList();

Which should provide you every element whose whereClause equals "ProjectNumber=a".

edited Jun 2, 2014 at 2:06

answered Jun 2, 2014 at 2:00

Johnathon Sullinger

7,4445 gold badges45 silver badges108 bronze badges

Comments

shree.pat18 · Accepted Answer · 2014-06-02 02:32:37Z

0

You can use the Attributes property to get the attribute from the XML node, along with the InnerText, like so:

XmlDocument doc = new XmlDocument();
doc.LoadXml(yourxml);

XmlNodeList xlist = doc.GetElementsByTagName("searchlayer");
for(int i=0;i<xlist.Count;i++)
 {
  Console.WriteLine(xlist[i].InnerText + " " + xlist[i].Attributes["whereClause"].Value);
 }

If you must use LINQ, you could use XDocument and then return anonymous class objects consisting of the attribute and text, like so:

XDocument xdoc = XDocument.Load(yourxmlfile);
var result = xdoc.Root.Elements("searchlayers").Elements("searchlayers").Select(x => new {attr = x.Attribute("whereClause").Value, txt = x.Value});
foreach (var r in result)
 {
  Console.WriteLine(r.attr + " " + r.txt);
 }

edited Jun 2, 2014 at 2:32

answered Jun 2, 2014 at 2:07

shree.pat18

21.8k3 gold badges45 silver badges65 bronze badges

Collectives™ on Stack Overflow

How to get XML Attribute and Element with One Linq Query?

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related