title: Linq-to-Entities: Format Date in select query expression
body: <p>I am trying to get a formatted date string directly from a LINQ-to-Entities query expression.</p>
  
  <pre><code>nonBusinessDays = (from ac in db.AdminCalendar
                     where ac.DateTimeValue &gt;= calendarStartDate &amp;&amp; ac.DateTimeValue &lt;= calendarEndDate &amp;&amp; ac.IsBusinessDay == false
                     select ac.MonthValue + "/" + ac.DayOfMonth + "/" + ac.FullYear).ToList();
  </code></pre>
  
  <p>But, I get the folloinw error message:
  "Unable to cast the type 'System.Nullable`1' to type 'System.Object'. LINQ to Entities only supports casting Entity Data Model primitive types."</p>
  
  <p>Is there any way to do this besides iterating through the result set?
  Thanks!
  Abe</p>