LINQ to Query XML in C#

Question

I have a very simple XML document

<content>
    <reference>
        <title>www</title>
        <url>http://xxx</url>
    </reference>
    <reference>
        <title>yyy</title>
        <url>http://zzz</url>
   </reference>
</content>

I'm trying to use LINQ to query each reference in turn to extract text in both title and url. There's nothing conditional in any of this, e.g., no where, and it seems simple, but I'm having terminal brain fade trying to get this done.

try this to load the doc "XDocument doc = XDocument.Load("yourfile.xml");" — PaulShovan
– PaulShovan, Commented May 27, 2015 at 12:02

Matias Cicero · Accepted Answer · 2015-05-27 12:23:56Z

4

You should start by instantiating a new XElement

XElement root = XElement.Parse(xmlString);

Then you can get all the child reference elements:

IEnumerable<XElement> references = root.Elements("references");

Let's suppose now that we have a class that holds a title and a url:

public class Info {
     public string Title { get; set; }
     public string Url { get; set; }
}

We can map our reference elements to these classes:

IEnumerable<Info> infos = references.Select(r => new Info() {
        Title = r.Element("title").Value,
        Url = r.Element("url").Value
});

edited May 27, 2015 at 12:23

answered May 27, 2015 at 12:05

Matias Cicero

26.5k21 gold badges91 silver badges160 bronze badges

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

2 Comments

peedurrr Over a year ago

That's just great; it produces the result and additionally adds a nice touch with the Info object. Very many thanks!

Matias Cicero Over a year ago

@peedurrr Glad I could be of help! ;)

Vlad Bezden · Accepted Answer · 2015-05-27 12:15:06Z

1

void Main()
{
    var xml = @"<content>
                    <reference>
                        <title>www</title>
                        <url>http://xxx</url>
                    </reference>
                    <reference>
                        <title>yyy</title>
                        <url>http://zzz</url>
                    </reference>
                </content>";


    XElement.Parse(xml).Elements("reference").ToList().ForEach(x => 
    {
        Console.WriteLine("Title: {0}, URL: {1}", x.Element("title"), x.Element("url"));
    });
}

answered May 27, 2015 at 12:15

Vlad Bezden

90.7k27 gold badges261 silver badges190 bronze badges

Comments

Ehsan Sajjad · Accepted Answer · 2015-05-27 12:50:27Z

1

You can use XDocument class with LINQ following way for it:

string MyXml = @"<RootNode>
                 ........
                 ........
                 </RootNode>";

XDocument xdoc= XDocument.Parse(MyXml);

var result =  from reference in xdoc.Descendants("reference")
              select new
                    {
                       Title = reference.Element("title").Value,
                       Url = reference.Element("url").Value
                    };

See this working DEMO

edited May 27, 2015 at 12:50

answered May 27, 2015 at 12:04

Ehsan Sajjad

62.6k16 gold badges112 silver badges171 bronze badges

Comments

jdweng · Accepted Answer · 2015-05-27 12:11:25Z

Try this

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Xml;
using System.Xml.Linq;

namespace ConsoleApplication30
{
    class Program
    {
        static void Main(string[] args)
        {
            string input =
                "<content>" +
                    "<reference>" +
                        "<title>www</title>" +
                        "<url>http://xxx</url>" +
                    "</reference>" +
                    "<reference>" +
                        "<title>yyy</title>" +
                        "<url>http://zzz</url>" +
                   "</reference>" +
                "</content>";

            XDocument doc = XDocument.Parse(input);

            var results = doc.Descendants("reference")
                .Select(x => new {
                    title = x.Descendants("title").FirstOrDefault().Value,
                    url = x.Descendants("url").FirstOrDefault().Value
                });
        }
    }
}

Collectives™ on Stack Overflow

LINQ to Query XML in C#

4 Answers 4

2 Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related