title: How to find out whether SqlCe query Has rows?
body: <p>In my simple db I use SqlCE and I cannot figure out how to correctly find out whether the query returns rows or not. <code>HasRows</code> does not work. So far I have this:</p>
  
  <pre><code>_DbCommand.CommandText="SELECT * FROM X"
  SqlCeDataReader reader=_DbCommand.ExecuteQuery();
  
  if (reader.FieldCount!=0) //I thought it could work (O rows - 0 fields?), but its true even with 0 rows
  {
      while (reader.Read())
      {
          //
      }
  }
  </code></pre>
  
  <p>Thanks</p>