title: EF not generating between clause
body: <p>The clause <code>Where(i =&gt; i.TimeSt &gt;= date1 &amp;&amp; i.TimeSt =&lt; date2)</code> is not being translate to <code>where TimeSt between @date1 and @date2</code> . How can I tell EF to use it?</p>
  
  <p><strong>Edit1</strong><br>
  this is a simplified version of the query. The original one handles over 17 dates.</p>
  
  <p><strong>Edit2</strong><br>
  <code>date1</code> and <code>date2</code> are standards .Net DateTime objects that has significant date part and time part (e.g.: 2017-01-05 21:15:21.123) </p>