title: Matching sql date with .NET date
body: <p>Should the following always match:</p>
  
  <pre><code>if(mydbrecord.DateField.Date == DateTime.Now.Date)
  {...}
  </code></pre>
  
  <p>where mydbrecord date is the current day?  I'm retrieving mydbrecord through linq-sql.</p>
  
  <p>mydbrecord.DateField.Date is in the format '2013-12-19 00:00:00.000'.</p>