title: LINQ query on a DataTable
body: <p>I'm trying to perform a LINQ query on a DataTable object and bizarrely I am finding that performing such queries on DataTables is not straightforward. For example:</p>
  
  <pre><code>var results = from myRow in myDataTable
  where results.Field("RowNo") == 1
  select results;
  </code></pre>
  
  <p>This is not allowed. How do I get something like this working?</p>
  
  <p>I'm amazed that LINQ queries are not allowed on DataTables!</p>