title: comparing datetime less than or equal to not working
body: <p>I have a query that gets data from the database. The user can select a date range for getting the data. I want my date range filters to be inclusive, so if a user selects date from and date to, the query should do the following:</p>
  
  <pre><code>all dates &gt;= date FROM
  AND
  all dates &lt;= date TO
  </code></pre>
  
  <p>this is working fine for the date FROM, I'm getting everything greater AND equal to the date FROM. But for date TO, its not including the date, just getting everything LESS than the date TO.</p>
  
  <p>here's the code:</p>
  
  <pre><code>query = query
     .Where(x =&gt; x.TradeDt &gt;= tradeDFrom)
     .Where(x =&gt; x.TradeDt &lt;= tradeDTo);
  </code></pre>