XML Linq Reading multiple nodes

Question

I'm trying to extract data from a wordpress blog xml feed, this is the format of the xml: http://brockallen.com/category/asp-net/feed/

var xElements = XElement.Parse(ResponseText);
var blogs = (from temp in xElements.Elements()
             select new 
             {
                 Title = temp.Element("item").Element("title").Value,
                 URL = temp.Element("item").Element("link").Value,
                 Image = temp.Element("item").Element("media:content").Value
             }).FirstOrDefault();

How do I get them all, and store them in to an object?

Error on media:content is saying The ':' character, hexadecimal value 0x3A, cannot be included in a name.`

When I remove that line, it only gets one, when there are more, even after removing FirstOrDefault()

You're explicitly calling FirstOrDefault. If you don't just want the first item, don't do that :) — Jon Skeet
– Jon Skeet, Commented Sep 22, 2014 at 15:19
@JonSkeet Hmm, I took that out and it works, but still only returns 1, when there's more — Control Freak
– Control Freak, Commented Sep 22, 2014 at 15:21
The blogs variable has only [0] = 1 result in Results View — Control Freak
– Control Freak, Commented Sep 22, 2014 at 15:23
@GeorgePolevoy please review brockallen.com/category/asp-net/feed for an example — Control Freak
– Control Freak, Commented Sep 22, 2014 at 15:27

George Polevoy · Accepted Answer · 2014-09-22 15:59:20Z

2

Your are working on the wrong level of the document. Also you need an namespace.

  XNamespace media = "http://search.yahoo.com/mrss/";
  var items =
  from channelElement in XElement.Parse(ResponseText).Element("channel").Elements("item")
  select new {
    Title = channelElement.Element("title").Value,
    Url = channelElement.Element("link").Value,
    MediaItems = (
        from mediaItemElement in channelElement.Elements(media + "content")
        select new {
            url = mediaItemElement.Attribute("url").Value,
            medium = mediaItemElement.Attribute("medium").Value
            }
        ).ToList()
  };

edited Sep 22, 2014 at 15:59

answered Sep 22, 2014 at 15:31

George Polevoy

7,7733 gold badges41 silver badges63 bronze badges

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

4 Comments

Control Freak Over a year ago

Yes, this works great. Thanks.. Except its throwing an error when I try to get media:content node: The ':' character, hexadecimal value 0x3A, cannot be included in a name.

Jon Skeet Over a year ago

@ZeeTee: That's because it's using a namespace with an alias of media. Look up using namespaces in LINQ to XML.

Control Freak Over a year ago

Is there a way to easily plug it in your code or is it a larger task than your code

George Polevoy Over a year ago

updated the answer so you are able to show media:content as a list

Tony Stark · Accepted Answer · 2014-09-22 15:51:34Z

1

Try this...updated with namespace for querying content element

    // var xDoc = XDocument.Load(@"<your xml location>");
    var xDoc = XDocument.Parse("<your xml string>");
    XNamespace ns = "http://search.yahoo.com/mrss/";

    var blogs = (from temp in xDoc.Descendants().Elements("item")
                 select new
                 {
                     Title = temp.Element("title").Value,
                     URL = temp.Element("link").Value,
                     Image = temp.Element(ns + "content").Value
                 });

edited Sep 22, 2014 at 15:51

answered Sep 22, 2014 at 15:42

Tony Stark

7616 silver badges22 bronze badges

2 Comments

George Polevoy Over a year ago

this way you can only get the first media item for each title, while there are a lot of them in your document

Tony Stark Over a year ago

to get all content elements, just use Image = temp.Elements(ns + "content") or if only image urls are needed then - Image = temp.Elements(ns + "content").Attributes("url")

Collectives™ on Stack Overflow

XML Linq Reading multiple nodes

2 Answers 2

4 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related