title: LINQ to SQL - Select property differences
body: <p>I have two cases:</p>
  
  <p><strong>1:</strong> <code>.....FirstOrDefault().Description</code></p>
  
  <p><strong>2:</strong> <code>......Select(y =&gt; y.Description).FirstOrDefault()</code></p>
  
  <p>I suspect that the first case constructs a SQL QUERY that returns all the columns from AAA and the second case constructs : <code>*SELECT DESCRIPTION FROM TABLE*</code>.</p>
  
  <p>I am right?</p>
  
  <p>What are the other differences between them ? Why use one case over the other?</p>