title: Parsing xml with XDocument and XPath
body: <pre><code>&lt;REETA xmlns="http://pria.org"&gt;
        &lt;AFFIDAVIT&gt;
        &lt;COUNTY_NAME&gt;BOBBIES COUNTY&lt;/COUNTY_NAME&gt; 
        &lt;DOC_TYPE&gt;DEED&lt;/DOC_TYPE&gt; 
        &lt;DOC_DATE&gt;2010-02-19T05:14:58&lt;/DOC_DATE&gt; 
        &lt;GROSS_SELL_PRICE&gt;200000.00&lt;/GROSS_SELL_PRICE&gt; 
        &lt;TAXABLE_SELL_PRICE&gt;200000.00&lt;/TAXABLE_SELL_PRICE&gt; 
        &lt;EXCISE_TAX_STATE&gt;2560.00&lt;/EXCISE_TAX_STATE&gt; 
        &lt;EXCISE_TAX_LOCAL&gt;500.00&lt;/EXCISE_TAX_LOCAL&gt; 
        &lt;DELQ_INT_STATE&gt;0.00&lt;/DELQ_INT_STATE&gt; 
        &lt;DELQ_INT_LOCAL&gt;0.00&lt;/DELQ_INT_LOCAL&gt; 
        &lt;DELQ_PENALTY&gt;0.00&lt;/DELQ_PENALTY&gt; 
        &lt;SUB_TOTAL&gt;3060&lt;/SUB_TOTAL&gt; 
        &lt;STATE_TECH_FEE&gt;5.00&lt;/STATE_TECH_FEE&gt; 
        &lt;PROCESSING_FEE&gt;0.00&lt;/PROCESSING_FEE&gt; 
        &lt;TOTAL_DUE&gt;3065&lt;/TOTAL_DUE&gt; 
      - &lt;INDIVIDUAL type="Buyer"&gt;
        &lt;NAME&gt;JANE DOE&lt;/NAME&gt; 
        &lt;/INDIVIDUAL&gt;
      - &lt;INDIVIDUAL type="Seller"&gt;
        &lt;NAME&gt;JON DOE&lt;/NAME&gt; 
        &lt;/INDIVIDUAL&gt;
      - &lt;PARCEL&gt;
        &lt;NUMBER&gt;3141614&lt;/NUMBER&gt; 
        &lt;/PARCEL&gt;
        &lt;/AFFIDAVIT&gt;
  &lt;/REETA&gt;
  
  
  var affidavits = xDocument.Descendants("AFFIDAVIT");
  var affidavitsTest = xDocument.XPathEvaluate("/reeta/AFFIDAVIT/COUNTY_NAME");
  </code></pre>
  
  <p>Above is xml which I am consuming from a third party source. For some reason I cannot parse through the xml with either method I describe above. Any insight would be very helpful thank you very much</p>