title: Linq Query with DateTime Compare is not Working as Expected
body: <p>At approximately 12/1/2014 9:40:12 PM, the following code retrieves a null value. </p>
  
  <pre><code>Campaign camp = repo.Campaigns
                      .Where(ca =&gt; ca.StartTime &lt;= DateTime.Now)
                      .Where(ca =&gt; ca.EndTime &gt;= DateTime.Now)
                      .FirstOrDefault();
  </code></pre>
  
  <p>When there is a campaign in the database with the following values:</p>
  
  <pre><code>Start Time:
  2014-11-30 00:00:00.000
  
  End Time:
  2014-12-02 00:00:00.000
  </code></pre>
  
  <p>I am at a complete loss why this would occur.</p>