title: Create dates between two date range values from c#
body: <p>I have a question on Date difference in (My)Sql with c#. <br/>
  In my database, I have a table containing date ranges like the following:</p>
  
  <pre>
  ------------------------
  From date      to date
  -------------------------
  2012-07-01    2012-07-03
  2012-07-05    2012-07-07
  2012-07-10    2012-07-12
  2012-07-13    2012-07-16
  --------------------------
  </pre>
  
  <p>From those ranges, i want to calculate all included dates as result, i.e.:</p>
  
  <pre>
  2012-07-01 
  2012-07-02 
  2012-07-03 
  2012-07-05 
  2012-07-06 
  2012-07-07 
  2012-07-10 
  2012-07-11 
  2012-07-12 
  2012-07-13 
  2012-07-14 
  2012-07-15
  2012-07-16
  </pre>
  
  <p><code>SELECT DATEDIFF('2012-01-01', '2012-02-02')</code> does not work as I expect,
  it gives only total number of days... i want all the dates between this, including the dates of the range (FromDate and ToDate).</p>
  
  <p>Can you show me how I can implement this (in SQL or C#) ?</p>