title: C# - IQueryable query how to select?
body: <pre><code>IQueryable&lt;ImportNameValidation&gt; query = entities.ImportNameValidation
      .Where(y =&gt; y.FirstName == searchedName)
      .Where(x =&gt; x.NameType == comboValue);
  
  List&lt;ImportNameValidation&gt; ResultValues = query.ToList();  
  </code></pre>
  
  <p>In this query, I get back 6 columns but I only need 3 of them, how can I use the select method to get only those columns that I need?
  is it something like  </p>
  
  <pre><code>.Select(t =&gt; t.FirstName, u =&gt; u.Name, i =&gt; i.NameCode);
  </code></pre>
  
  <p>what I really want in SQL is instead of "select *" I want to "select NameCode, Name, FirstName" but I need that as an IQueryable.</p>