Programming Data-Driven Web Applications with ASP.NET

Managed Commands

Managed Commands represent SQL syntax to be executed on the data store. Managed Commands can be simple SELECT statements or complex, parameterized commands.

Once a connection to a data store is established, you can retrieve, update, or insert data. One way of accomplishing this is to use a Managed Command. This is the most direct way to execute a SQL statement on a data store.

As with the Managed Connection object, there are both OleDb and SQL versions of the Managed Command—OleDbCommand and SqlCommand.

The Managed Command is similar to the classic ADO command object. In its simplest form, you create a Managed Command with the SQL statement and the connection (as either a ConnectionString or a Managed Connection object) as its ...