SQL statements and stored procedures can be run using provider-specific Command objects.
Data returned by Command objects can be accessed through provider-specific DataReader objects.
Command objects have parameter collections that can contain one or more parameters for executing parameterized queries and stored procedures.
BLOB data can be saved and retrieved from a database using DataReaders and Stream objects.
Bulk copy operations can be performed using the SqlBulkCopy object as well as by executing a SQL BULK INSERT statement.
Commands can be executed within the context of a local transaction, or a command can be enlisted in a distributed transaction.
Was this article helpful?