Regarding a query in LINQ to XML

[sanndeb]

Hi, Hope everybody is file here....

I have an xml like this

<?xml version="1.0" encoding="utf-8" ?>
<Holidays>
    <year year="2010">
            <holiday day="03/01/2010" />
            <holiday day="03/02/2010" />
        </year>
        <year year="2011">
            <holiday day="03/01/2011" />
            <holiday day="03/02/2011" />
            <holiday day="03/03/2011" />
        </year>
</Holidays>

Now I want an string array of holidays for year 2010
I'm trying something like

XDocument holidays = XDocument.Load("path to xml/ xmlreader");
var days = from el in holidays.Root.Elements("year")
            where el.Attribute("year").Value == "2010"
             select el.Elements("holiday");
foreach (var date in days)
{
// But here date is not what i want like '03/01/2010' or '03/02/2010'
}
 

Can you please suggest how to extract the holidays for year 2010 from the xml.

Thanks :)

Edit: And also how do i do the same when the xml is of the form

<?xml version="1.0" encoding="utf-8"?>
<Holidays>
  <Year Year="2010">
    <Holiday>"03/01/2010"</Holiday>
    <Holiday>"05/27/2010"</Holiday>
  </Year>
  <Year Year="2011">
    <Holiday>"03/01/2011"</Holiday>
    <Holiday>"05/27/2011"</Holiday>
  </Year>
 
</Holidays>
 

[Christian Binder]

date is of type XElement (holiday), you've to extract it's day-attribute and read it's value.
e.g.
date.Attributes("day").First().Value;

In your second example, the date is the value of your date-XElement, so you'd just have to do date.Value within you foreach-loop.

[sanndeb]

Thats ok to get the values using date.Attributes("day").First().Value inside the foreach loop... but what i wanted is to extract the dates directly using linq not inside another foreach loop.... i.e like at the end of the linq query i'll add a toList() method so that all day's will be listed in a list of string.

[Christian Binder]

Sure you can do this

var days = from el in holidays.Root.Elements("year")
           where el.Attribute("year").Value == "2010"
           let holidayElem = el.Elements("holiday")
           let attrib = holidayElem.Attributes("day").FirstOrDefault()
           where attrib != null
           select attrib.Value;
 

[sanndeb]

But your query is returning only the first day of year 2010 i.e '03/01/2010', but the output should be of two days...'03/01/2010' & '03/02/2010'

[Christian Binder]

Oh, I'm sorry.

var days = from el in holidays.Root.Elements("year")
           where el.Attribute("year").Value == "2010"
           from holidayElem in el.Elements("holiday")
           let attrib = holidayElem.Attributes("day").FirstOrDefault()
           where attrib != null
           select attrib.Value;
 

[sanndeb]

Yes thats it mate... getting the results perfectly... thanks a lot :)