title: LINQ To Entities does not recognize the method Last. Really?
body: <p>In this query:</p>
  
  <pre><code>public static IEnumerable&lt;IServerOnlineCharacter&gt; GetUpdated()
  {
      var context = DataContext.GetDataContext();
      return context.ServerOnlineCharacters
          .OrderBy(p =&gt; p.ServerStatus.ServerDateTime)
          .GroupBy(p =&gt; p.RawName)
          .Select(p =&gt; p.Last());
  }
  </code></pre>
  
  <p>I had to switch it to this for it to work</p>
  
  <pre><code>public static IEnumerable&lt;IServerOnlineCharacter&gt; GetUpdated()
  {
      var context = DataContext.GetDataContext();
      return context.ServerOnlineCharacters
          .OrderByDescending(p =&gt; p.ServerStatus.ServerDateTime)
          .GroupBy(p =&gt; p.RawName)
          .Select(p =&gt; p.FirstOrDefault());
  }
  </code></pre>
  
  <p>I couldn't even use <code>p.First()</code>, to mirror the first query.</p>
  
  <p>Why are there such basic limitations in what's otherwise such a robust ORM system?</p>