title: Linq where clause compare only date value without time value
body: <pre><code>var _My_ResetSet_Array = _DB
      .tbl_MyTable
      .Where(x =&gt; x.Active == true
          &amp;&amp; x.DateTimeValueColumn &lt;= DateTime.Now)
      .Select(x =&gt; x);
  </code></pre>
  
  <p>Upper query is working correct.<br> 
  But I want to check only date value only.<br>
  But upper query check date + time value.</p>
  
  <p>In traditional mssql, I could write query like below.</p>
  
  <pre><code>SELECT * FROM dbo.tbl_MyTable
  WHERE 
  CAST(CONVERT(CHAR(10), DateTimeValueColumn, 102) AS DATE) &lt;= 
              CAST(CONVERT(CHAR(10),GETDATE(),102) AS DATE)
  AND
  Active = 1
  </code></pre>
  
  <p>So could anyone give me suggestion how could I check only date value in Linq.</p>