ADO has provider classes that connect us to databases.  These classes can be used with sql, oracle, etc.

(Connected) Provider Classes:

DB Connection - connects to a database

DB Command - executes commands (Select)

DB Data Reader - used in conjunction with the select statement.  Reads through data set line by line.

DB Data Adapter - works with Data Set to read data from database and then write it back.


It also has other classes that store data

Container Classes (Disconnected)

Data Set - A very complex heavyweight object that can hold an entire relational database.  This would exist in memory while using application. (Kind of like a copy of the database that can be manipulated and then is later copied to the database)

Data Table - Used to manipulate data in a control (aka a table).


When using the SQL commands, there are different codes to use.

Select - ExecuteReader

Insert
Update - Execute Selection Query