title: Multiple Active Result Sets in NCache
body: <p>I have been evaluating NCache since the last few weeks. Mu question is specific to techniques for querying the cache data. I'm looking for something similar to the ADO.NET technique mentioned below. The requirement to to supply multiple queries at a go and iterate through the result set one by one.</p>
  
  <p>The ADO.NET code for fetching in the above mentioned fashion from database looks like this.</p>
  
  <pre><code>connetionString = "Data Source=ServerName;Initial Catalog=DatabaseName;User ID=UserName;Password=Password";
              sql = "Select top 2 * from product; select top 2 * from ordermaster; select top 2 * from orderdetails";
  
              sqlCnn = new SqlConnection(connetionString);
              try
              {
                  sqlCnn.Open();
                  sqlCmd = new SqlCommand(sql, sqlCnn);
                  SqlDataReader sqlReader = sqlCmd.ExecuteReader();
                  while (sqlReader.Read())
                  {
                      MessageBox.Show ("From first SQL - " + sqlReader.GetValue(0) + " - " + sqlReader.GetValue(1));
                  }
  
                  sqlReader.NextResult();
  
                  while (sqlReader.Read())
                  {
                      MessageBox.Show("From second SQL - " + sqlReader.GetValue(0) + " - " + sqlReader.GetValue(1));
                  }
  
                  sqlReader.NextResult();
  
                  while (sqlReader.Read())
                  {
                      MessageBox.Show("From third SQL - " + sqlReader.GetValue(0) + " - " + sqlReader.GetValue(1));
                  }
  
                  sqlReader.Close();
                  sqlCmd.Dispose();
                  sqlCnn.Close();
              }
  </code></pre>
  
  <p>Can we do something similar in NCache for querying the cache data ?</p>