title: Linq Syntax - Selecting multiple columns
body: <p>This is my Linq Syntax which I am using to my entity model</p>
  
  <pre><code>IQueryable&lt;string&gt; objEmployee = null;
  
  objEmployee = from res in _db.EMPLOYEEs
                where (res.EMAIL == givenInfo || res.USER_NAME == givenInfo)
                select res.EMAIL;
  </code></pre>
  
  <p>How can I select multiple columns? Like I want to select res.ID aswell. And how can I receive those? IQueryable will not work I think.
  And this is called Linq to SQL - right ?</p>