title: Can we delete a Data table row while reading it with SqlReader
body: <p>I Created two Stored Procedure one for reading Datarows and One for deleting, but I was wondering If I can delete records while reading them and also if its best practice ?</p>
  
  <p>e.g.</p>
  
  <pre><code>while (rdr.Read())
  {
      If(rdr[abc].ToString() != Null)
      {Maybe delete it ?}
  }
  </code></pre>
  
  <p><strong>My question is, Can I delete a row while reading it ? :)</strong></p>