title: SQL - Server + Entitiy Framework orderby<datetime>
body: <p>I want to order my projects by the last generated timestamp:</p>
  
  <pre><code>var projectsOrderd  = projects.OrderBy(r =&gt; r.Timestamps.Select(t =&gt; t.End));
  </code></pre>
  
  <p>but there is an error:
  "DbSortClause expressions must have a type that is order comparable"</p>
  
  <p>type of End: datetime</p>
  
  <p>is there any solution?</p>
  
  <p>ps: runnig the statment on the SQL-Server works fine</p>