title: Linq to SQL: select optimization
body: <p>On large tables in MSSQL; selecting specific columns results in greater speed of the query. Does the same apply to Linq to SQL?</p>
  
  <p>Would this:</p>
  
  <pre><code>var person = from p in [DataContextObject].Persons
               where p.PersonsID == 1
               select new { p.PersonsID, p.PersonsAdress, p.PersonsZipcode };
  </code></pre>
  
  <p>be faster than this:</p>
  
  <pre><code>var person = from p in [DataContextObject].Persons
               where p.PersonsID == 1
               select p;
  </code></pre>
  
  <p>... ?</p>