title: Selecting Many Fields From a Table using Linq and Lambda Expressions
body: <p>I have a <code>DataContext</code> (db) that can access the tables in my SQL Express database, from which I would like to extract only three of the multiple fields in the tblItem table:</p>
  
  <pre><code>// this does not work - what is the correct way to do it?  
  var items = db.tblItems.Select(i =&gt; i.id &amp;&amp; i.name &amp;&amp; i.totalAmount);
  </code></pre>
  
  <p>The intention is to spit these out into a csv file (comma separated). Is a <code>var</code> the best way to do this?</p>