Building a Reusable Data Access Library

As you have just seen, the ExecuteReader method extracts a data reader object that allows you to examine the results of a SQL Select statement using a forward-only, read-only flow of information. However, when you wish to submit SQL commands that result in the modification of a given table, you will call the ExecuteNonQuery method of your command object. This single method will perform inserts, updates, and deletes based on the format of your command text. Note Technically speaking, a nonquery...