title: linq, selecting columns as IEnumerable<DataRow>
body: <p>how can i do in linq:</p>
  
  <pre><code>IEnumerable&lt;DataRow&gt; query = 
          from rec in dt.AsEnumerable() 
          where rec.Field&lt;decimal&gt;("column2") == 1 &amp;&amp; foo(rec.Field&lt;decimal&gt;("column1"))
          select new {
              column1 = rec.Field&lt;decimal&gt;("column1"),
              column2 = rec.Field&lt;decimal&gt;("column2"),
              column3 = rec.Field&lt;decimal&gt;("column3")}  ;
  </code></pre>
  
  <p>this does not work. Im trying to select some columns as new datatable then join it later with some other datatable.</p>