title: Which LINQ statements force Entity Framework to return from the DB?
body: <p>I know of several LINQ statements that will cause EF to evaluate and return results form the DB to memory.  <code>.ToList()</code> is one.  Does anyone have a comprehensive list of the statements that do this?</p>
  
  <p>Not sure of...</p>
  
  <pre><code>.SingleOrDefault()
  .Union()
  </code></pre>
  
  <p><strong>EDIT:</strong> Wish I could accept all these answers.  Great info from everyone!</p>