title: SqlDataReader doesn't have third record set
body: <p>I have a Stored Procedure that returns three record sets. Here it is being called in Studio.</p>
  
  <pre><code>EXEC CampaignData '007CF7F8-AE8D-DE11-8BBA-0003FF4C13C9'  
  </code></pre>
  
  <p>I can't cut and paste the record sets from Management Studio but trust me it shows three record sets, first one has one row with 2 values, the second has three rows and the third has 2 rows.</p>
  
  <p>Here is my c# reading it</p>
  
  <pre><code>using (DAResult daResult = DA.SP.CampaignData(new Guid("007CF7F8-AE8D-DE11-8BBA-0003FF4C13C9")).Execute())
  {
  daResult.Read();
  UserCount = daResult.ValueInt("UserCount");
  ProspectCount = daResult.ValueInt("ProspectCount");
  
  daResult.Next();
  EmailTemplates = new DataTable();
  EmailTemplates.Load(daResult.Reader);
  
  daResult.Next();
  SMSTemplates = new DataTable();
  SMSTemplates.Load(daResult.Reader);
  }
  </code></pre>
  
  <p>Next() just calls NextResult on the Reader.
  When I get to the last line the reader has no rows in it.  Like the last record set returned no rows.  Yet it does.  All the rest of the values return fine.</p>
  
  <p>Does anybody have any ideas why this might be?</p>