title: Sort collection by first item of sub list in Entity Framework
body: <p>Is it possible to sort <code>IQueryable</code> collection by it's sub collections?</p>
  
  <p>For example I have a <code>Books</code> collection. I also have an <code>Authors</code> collection which has a column <code>BookId</code>, so the <code>BookId</code> is a foreign key in <code>Authors</code> table. The relation is one-to-many (one book many authors).</p>
  
  <p>I need to sort the <code>Books</code> collection by the first author. The book is not required to have an author. Can this be done in Entity Framework and Linq?</p>