title: how to retrieve data between two dates in linq
body: <p>I have a datetime column in a table and I want to retrieve data month wise from this date time column. I want to populate a dropdown down list with month name only so that user can search data by month name. 
  here is my linq code</p>
  
  <pre><code>        var filterdate = from dates in _db.entries
                           where date1 &gt;= dates.PaidOn
                           where date2 &lt;= dates.PaidOn
                           select dates;
          return View(filterdate);           
  </code></pre>
  
  <p>and how to write the razor view code. please help. I am stuck. I would really appreciate your help. thanks in advance. Gitu</p>