title: Reading XML element & child nodes using LINQ in Vb.net- help me in where condition :(
body: <p>I need an help in reading the xml elements using LINQ with specific where condition.</p>
  
  <p>I need to find the max air_temp for a county 
  i.e where county name = "Boone"  and hour id = "06/03/2009 09:00CDT"</p>
  
  <p>i tried something like below, but no luck:</p>
  
  <pre><code> Dim custs As IEnumerable = From c In Element.Load("C:\meridian.xml").Elements("county") _
                              Select c.Elements("hour").Elements("air_temp").Max()
  
   For Each x In custs
          Response.Write(custs(0).ToString())
   Next
  </code></pre>
  
  <p>------------------- here is the xml file :</p>
  
  <pre><code> &lt;forecasts&gt;
        &lt;issued&gt;06/02/2009 12:00CDT&lt;/issued&gt; 
      - &lt;county name="Adair"&gt;
      - &lt;hour id="06/02/2009 12:00CDT"&gt;
            &lt;air_temp&gt;61&lt;/air_temp&gt; 
            &lt;cloud_cover&gt;overcast&lt;/cloud_cover&gt; 
            &lt;dew_point&gt;59&lt;/dew_point&gt; 
            &lt;precip_prob&gt;90&lt;/precip_prob&gt; 
            &lt;precip_rate&gt;0.12&lt;/precip_rate&gt; 
            &lt;precip_type&gt;rain&lt;/precip_type&gt; 
            &lt;snow_rate&gt;0.0&lt;/snow_rate&gt; 
            &lt;wind_direction&gt;NE&lt;/wind_direction&gt; 
            &lt;wind_speed&gt;12&lt;/wind_speed&gt; 
            &lt;dew_point_confidence&gt;-3/+3&lt;/dew_point_confidence&gt; 
            &lt;road_temp&gt;64&lt;/road_temp&gt; 
            &lt;road_frost_prob&gt;0&lt;/road_frost_prob&gt; 
            &lt;road_potential_evap_rate&gt;429&lt;/road_potential_evap_rate&gt; 
            &lt;road_temp_confidence&gt;-3/+2&lt;/road_temp_confidence&gt; 
            &lt;dew_point_confidence&gt;-3/+3&lt;/dew_point_confidence&gt; 
            &lt;bridge_temp&gt;63&lt;/bridge_temp&gt; 
            &lt;bridge_temp_confidence&gt;-4/+2&lt;/bridge_temp_confidence&gt; 
            &lt;bridge_frost&gt;NO&lt;/bridge_frost&gt; 
        &lt;/hour&gt;
      - &lt;hour id="06/02/2009 13:00CDT"&gt;
            &lt;air_temp&gt;61&lt;/air_temp&gt; 
            &lt;cloud_cover&gt;overcast&lt;/cloud_cover&gt; 
            &lt;dew_point&gt;60&lt;/dew_point&gt; 
            &lt;precip_prob&gt;70&lt;/precip_prob&gt; 
            &lt;precip_rate&gt;0.01&lt;/precip_rate&gt; 
            &lt;precip_type&gt;rain&lt;/precip_type&gt; 
            &lt;snow_rate&gt;0.0&lt;/snow_rate&gt; 
            &lt;wind_direction&gt;ENE&lt;/wind_direction&gt; 
            &lt;wind_speed&gt;10&lt;/wind_speed&gt; 
            &lt;dew_point_confidence&gt;-3/+3&lt;/dew_point_confidence&gt; 
            &lt;road_temp&gt;65&lt;/road_temp&gt; 
            &lt;road_frost_prob&gt;0&lt;/road_frost_prob&gt; 
            &lt;road_potential_evap_rate&gt;411&lt;/road_potential_evap_rate&gt; 
            &lt;road_temp_confidence&gt;-3/+2&lt;/road_temp_confidence&gt; 
            &lt;dew_point_confidence&gt;-3/+3&lt;/dew_point_confidence&gt; 
            &lt;bridge_temp&gt;64&lt;/bridge_temp&gt; 
            &lt;bridge_temp_confidence&gt;-4/+1&lt;/bridge_temp_confidence&gt; 
            &lt;bridge_frost&gt;NO&lt;/bridge_frost&gt; 
        &lt;/hour&gt;
  </code></pre>