Reading RSS feed node using Linq query

Question

In the following example could you suggest what's the best way to read "ApplicationUrl" value using linq.

<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:a10="http://www.w3.org/2005/Atom" version="2.0">
   <channel>
      <title>TestTitle</title>
      <item>
         <a10:content type="application/xml">
            <Vacancy xmlns="http://schemas.datacontract.org/2004/08/Har" xmlns:i="http://www.w3.org/2001/XMLSchema-instance">
               <AdvertText i:nil="true" />
               <ApplicationUrl>http://www.Test.co.uk/test/Sec/signin.aspx?vid=685</ApplicationUrl>
            </Vacancy>
         </a10:content>
      </item>
   </channel>
</rss>

I am trying to read using following linq query but stuck at content level

(from node in doc.Elements("channel").Elements("item")
 select new
 {
     Link = "link: " +node.Element("link").Value,
     Title = "Title: "+node.Element("title").Value,
     UpdatedOn ="Updated on : "+  node.Element(atom + "updated").Value,
     //here I have problem for getting Content properly
     Content = "Vacancy : " + XElement(node.Element(atom + "Vacancy"))
 })

har07 · Accepted Answer · 2014-07-22 01:27:21Z

1

You can try this way :

XNamespace ns = "http://schemas.datacontract.org/2004/08/Har";
XNamespace a10 = "http://www.w3.org/2005/Atom";
......
......
(from node in doc.Elements("channel").Elements("item")
 select new
 {
     Link = "link: " + (string)node.Element("link"),
     Title = "Title: "+ (string)node.Element("title"),
     UpdatedOn ="Updated on : "+ (string)node.Element(atom + "updated"),
     Content = "Vacancy : " + (string)node.Element(a10+"content")
                                          .Element(ns+"Vacancy")
                                          .Element(ns+"ApplicationUrl")
 })

answered Jul 22, 2014 at 1:27

har07

89.5k12 gold badges87 silver badges143 bronze badges

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

Collectives™ on Stack Overflow

Reading RSS feed node using Linq query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related