title: Linq to SQL select multiple columns
body: <p>I just want to select 2 columns from a MSSQL DB using LINQ.</p>
  
  <p>The SQL should be</p>
  
  <pre><code>select table.col1,table.col2 from table
  </code></pre>
  
  <p>I tried</p>
  
  <pre><code>IList&lt;string&gt; myResults =
  (
      from data in dbconn.table
      where table.col5 == null
      select new { 
          col1=data.Id.ToString(),
          col2=data.col2
      }
  ).Take(20).ToList();
  </code></pre>
  
  <p>but this didn't work.</p>
  
  <p>It says</p>
  
  <pre><code>cannot convert type  list &lt;AnonymousType#1&gt; to Ilist&lt;string&gt;
  </code></pre>