title: LINQ: Rewrite an inline query into Linq method style?
body: <p>How could this be re-written using LINQ methods instead of inline query style?</p>
  
  <pre><code>var cp = from DataRow r in rptDataPkg.Datasets.Item(0).Result.Rows
                  where (r.Field&lt;string&gt;("UnitItem") == "PC") &amp;&amp;
                        (r.Field&lt;string&gt;("UnitItem") == "Hs") &amp;&amp;
                        (r.Field&lt;string&gt;("UnitItem") == "U")
                  select new CurrProjected 
                  { 
                      doAddUp = (r.Field&lt;Decimal&gt;("Fld1") + r.Field&lt;Decimal&gt;("Fld2")) 
                                  == r.Field&lt;Decimal&gt;("Fld3")
                  };
  </code></pre>