Chapter Summary

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.

0 0

Post a comment