title: Retrieving all rows from sqlce in a single fetch
body: <p>I have a query for the SQLCE database like </p>
  
  <pre><code>     select mobileNumber from customers where balance &gt; 10000
  </code></pre>
  
  <p>Till now, I was looping over the SqlCeResultSet like</p>
  
  <pre><code>     while (resultSet.Read())
       {
           mobileNumberList.Add(resultSet.GetValue(0));
       } 
  </code></pre>
  
  <p>So I want to get the list of mobile numbers in a single fetch may be as a list. How do i do that? Because the getting in a single fetch will be faster, right?</p>
  
  <p><strong>UPDATE</strong><br>
  Few things I read after reading the answers:<br>
  <a href="https://stackoverflow.com/questions/1676753/sqldataadapter-vs-sqldatareader">SqlDataReader vs SqlDataAdapter</a></p>