C# using linq to parse xml

I would like to parse an xml file using linq in a C#2010 application. Listed below you will find an example of an xml file I want to parse. I would like to use the  code listed  below to parse the an xml file. Thus I am wondering if you can show me how to use the code I listed below to parse the xml displayed below and/or show me code that will accomplish this goal?


The following is the code:
using System;
using System.Linq;
using System.Xml.Linq;
class Program
{
  static void Main()
  {
  XDocument document = XDocument.Load(@"d:\test.xml");
  var priceInfo = from e in document.Descendants("MPrice").Elements("Price")
  let start = DateTime.Parse(e.Descendants("StartDt").FirstOrDefault().Value)
  let end = DateTime.Parse(e.Descendants("EndDt").FirstOrDefault().Value)
  where start < DateTime.Now && end > DateTime.Now
  select new { Id = e.Parent.Element("Id").Value, ListPrice = e.Element("ListPrice").Value };
  Console.WriteLine(priceInfo.FirstOrDefault().Id);
  Console.WriteLine(priceInfo.FirstOrDefault().ListPrice);
  }
}
The following is the metatag:
http://test1/test">
  Package Details retrieved Successfully
 
  type2
  dog
  Co 1
  0
 
  3
 
 
  Spreadsheet1
  pkg1
 
 
 
 
  Spreadsheet2
  pkg1