C# - filling in empty dates in a collection
<p>Assume that the class <strong>Data</strong> is defined as <strong>{DateTime TransactionDate, int ItemCount}</strong>.
I get an original IEnumerable containing scattered TransactionDates and ItemCounts and I need to write a method that returns a collection with all the days filled in between the minimum and the maximum days in the original collection.</p>

<p>For instance, if I get:<br/>
12/5/2009 15.00 <br>
12/7/2009 10.00 <br>
12/10/2009 75.00 <br></p>

<p>I need to generate something like this:<br>
12/5/2009 15.00 <br>
12/6/2009 0.00 <br>
12/7/2009 10.00 <br>
12/8/2009 0.00 <br>
12/9/2009 0.00 <br>
12/10/2009 75.00 <br></p>

<p>Get you give me an elegant way of doing this with c# 3.0?</p>

<p>I have a list of all dates between the minimum and maximum dates. So I assume all I have to do is "foreach" the intersect collection (allDates-existingDates) and insert a new element for each of these. Am I right? </p>

<p>Thanks</p>
