title: EF : using into statement with one single table
body: <p>With my EF5 I can do this for instance:</p>
  
  <pre><code>var result = (from p in entity.person
               join d in entity.dept on p.IdDept equals d.Id
               into dp from d in DefaultIfEmpty()
               select {
                   IdPerson = p.Id,
                   Depts = dp.Select(r =&gt; r.DepName).Distinct()
               }).ToList()
  </code></pre>
  
  <p>This is just an ugly example but it works fine, the use of the 'into dp' makes me manipulate the result and make my own grouping without having to use the 'group by' statement.</p>
  
  <p>Now suppose I have only one single table, and I want to use the into statement :</p>
  
  <pre><code>var result = (from p in entity.person into pp ...
                   select {
                       something = pp.Select(r=&gt; ...
               }).ToList()
  </code></pre>
  
  <p>the into statement here gives a compilation error when using a single table : </p>
  
  <blockquote>
    <p>A query body must end with a select clause or a group clause</p>
  </blockquote>
  
  <p>can anybody explain to me why ? </p>