title: Error, method not supported by LINQ to Entities
body: <p>Why I am getting this error:</p>
  
  <p><strong><em>The method 'Single' is not supported by LINQ to Entities. Consider using the method 'First' instead.</em></strong></p>
  
  <pre><code>           public ActionResult Details(int id)
  Line 27:   {              
               var result = (from d in _db.MovieSet
  Line 29:     where d.Id == id
  Line 30:     select d).Single();
              //
              //
             } 
  </code></pre>
  
  <p>Code compiles safe, but only breaks if call is made to the respective section. I am new to LINQ, therefore do not know which methods are for LINQtoSQL or LINQtoEntities.  This means more errors! We cannot remember all methods this way.</p>
  
  <p>My question is, if there are limitations to the methods applicable to certain types / scenarios, why do they appear in Intellisense?</p>
  
  <p><strong>EDIT:</strong> Any work-around / technique helpful to have an idea if one is supported ?</p>