title: ExecuteReader not returning all records returned by stored procedure
body: <p>I am using <code>ExecuteReader</code> of <code>Microsoft.Practices.EnterprizeLibrary</code> to fetch data from database. the store procedure that i have created returning two records but the <code>ExecuteReader</code> giving me one record. i am confused why it is happening. i am using following line of code.</p>
  
  <pre><code>public List&lt;Products&gt; GetProductsData(Products p)
      {
  
          List&lt;Products&gt; productList = new List&lt;Products&gt;();
          using (IDataReader rdr = dbt.ExecuteReader("pGetProducts",p.productType))
          while (rdr.Read())
              {
                  Products obj= new Products();
                  {
                      obj.Id = Common.CheckIntegerNull(rdr["id"]);
                      obj.AId = Common.CheckIntegerNull(rdr["aid"]);
                      obj.Name = Common.CheckStringNull(rdr["name"]);
                      obj.Price = Common.CheckDecimalNull(rdr["amt"]);
  
                  }
                  productList.Add(obj);
              }
          return productList;
      }
  </code></pre>
  
  <p>Thanks</p>