title: Separate dates between two dates
body: <p>I have a table that stores my sold products and this table has a column that stores date of bought.</p>
  
  <p>For example :</p>
  
  <pre><code>01/01/2015  200$
  02/01/2015  200$
  02/01/2015  200$
  02/01/2015  200$
  04/01/2015  200$
  05/01/2015  200$
  </code></pre>
  
  <p>I want to know how much I sold in 01 and 03.</p>
  
  <p>How can I select the data?</p>
  
  <p>I am using Entity Framework please give me solution in EF.</p>
  
  <pre><code>(from s in _db.SoldProducts 
   where s.SoldDate =&lt; "01/01/2015" and s.SoldDate =&gt; 03/01/2015).ToList();
  </code></pre>
  
  <p>something like this.</p>