title: multiple linq orderby not working
body: <p>I have multiple <code>OrderBy</code> but only the first order column is working</p>
  
  <pre><code>public static List&lt;vwData&gt; GetAllData(string startDate, string endDate)
  {
      DateTime dtStart = Convert.ToDateTime(startDate).Date;
      DateTime dtEndDate = Convert.ToDateTime(endDate).Date;
  
  
      var entities = new DataEntities();
      var query = from c in entities.vwData
                  let eventDate = EntityFunctions.TruncateTime(c.EventCreateDate)
                  orderby c.EventCreateDate ascending, c.StartDateTime ascending
                  where eventDate &gt;= dtStart &amp;&amp; eventDate &lt;= dtEndDate
                  select c;
      return query.ToList();
  }
  </code></pre>