title: LINQ-to-SQL: sorting related entity set at load time
body: <p>Imagine I have two tables ShowTimes and Movies. Each Movie can have a list of related ShowTimes. Say the ShowTimes table contains a DateTime field called StartTime. The ShowTimes can appear in the table in any order (the theatre manager can add new showings at any time).</p>
  
  <p>Therefore, the LINQ-to-SQL Movie object will contain a</p>
  
  <pre><code>public EntitySet&lt;ShowTime&gt; ShowTimes;
  </code></pre>
  
  <p>field, which will be loaded when it is first accessed.</p>
  
  <p>Is there any way to control the sort order of ShowTimes so that it will be sorted by StartTime when it is loaded? Or must I sort it myself before I use it? Can I control the “natural order” of the ShowTimes table – by default it is sorted by primary key (an integer, in my case), can I specify that it is to be sorted by StartTime?</p>