title: Trying to get day of week (mon, tue etc..) in linq to sql
body: <p>I'm using a linqdatasource for a gridview.
  On linqdatasource_selecting I wrote the following query to pass to <code>e.Result</code></p>
  
  <pre><code>Select o.localID, o.delivery_date, 
  dow = o.delivery_date.Value.DayOfWeek.ToString("ddd"), o.created_by
  o.customer_name, o.customer.OrderNum
  Order By delivery_date Descending
  </code></pre>
  
  <p>I'm getting to the following error</p>
  
  <blockquote>
    <p>Method 'System.String ToString(System.String)' has no supported
    translation to SQL.</p>
  </blockquote>
  
  <p>I've seen people saying to make the projection of <code>o.delivery_date.Value.DayOfWeek.ToString("ddd")</code>
  after getting the results with .ToLists</p>
  
  <p>The problem with this is that I will loose the efficiency of paging from the gridview since linq will get results from all pages instead of the one the gridiew is requesting.</p>
  
  <p>Any suggestions?</p>