title: Linq to Entities DateTime Conversion
body: <p>If given an entity with a DateTime as a string, what are my options to filter the data with LINQ to Entities on the date?</p>
  
  <p>It does not seem to support me doing DateTime conversions.</p>
  
  <p>Basically, I want to accomplish:              </p>
  
  <pre><code>var filtered = from item in entities.itemsSet
                 where Convert.ToDateTime(shift.starttime) &gt;= startDate 
                     &amp;&amp; Convert.ToDateTime(shift.endtime) &lt; endDate
                 select item;
  </code></pre>
  
  <p>What are my options to accomplish this?</p>