Chapter 5 talking points:
ADO.NET includes five key components used for most data access: database connection, data adapter, data set, data table, and data view.
ADO.NET provides typed data sets. Typed data sets use explicit names and data types that help prevent errors during programming.
Use data binding to quickly display data sets on Web forms through the DataGrid, DataList, or other list controls.
Create command objects to execute SQL commands directly on a database. Command objects can return a single value (ExecuteScalar), modify the database (ExecuteNonQuery), or return data (ExecuteReader).
Transactions group database commands so that they succeed or fail in an all-ornothing fashion. This ensures that changes are not partially made, thus preserving the integrity of the database.