title: Linq to SQL filter DateTime field by Year/Month
body: <p>I have <code>Statistic</code> table with many fields and one of them is <code>DateTime</code>. I need to find all records which are for current Year and Month. I am using query below but not sure is this optimal solution. </p>
  
  <pre><code>Statistics.Count(p =&gt; p.DateStamp.Year == DateTime.UtcNow.Year &amp;&amp; p.DateStamp.Month == DateTime.UtcNow.Month);
  </code></pre>