title: Cannot get data from DataSet for a specific id using Linq
body: <p>I tried to use different examples on this site but cannot find the one that solves my problem. </p>
  
  <p>I have a DataSet and I need to get all the rows from that DataSet using <code>Linq</code> with a given ID</p>
  
  <p>I'm doing the following:</p>
  
  <pre><code>foreach (DataRow dataRow in myData.Tables[0].Rows)
  {
      string id = dataRow["id"].ToString().Trim();
      var listOfData = myData.Tables[1].Rows.Cast&lt;DataRow&gt;().Where(x =&gt; x.Field&lt;string&gt;("id") == id);
  }
  </code></pre>
  
  <p>When doing that I have an error in <code>Field&lt;string&gt;</code> part saying that </p>
  
  <blockquote>
    <p>DataRow does not contain definition for Field and no extension method Field accepting a first argument of DataRow...</p>
  </blockquote>
  
  <p>I found another way of achieving that:</p>
  
  <pre><code>DataRow[] listOfData = myData.Tables[1].Select("id=" + id);
  </code></pre>
  
  <p>and it works, but I do not want to use DataRow[] and want to use Linq's query with <code>where</code> clause </p>
  
  <p>What am I missing and is there another way of doing that?</p>