Monday, October 18, 2010

Applications and Databases

We keep them separate

1 Connection string -Address of the supermarket

DB Drivers
Path to DB

2 Connection Object - Car/Road
Using the connection string

3 Command Object-Shopping List
SQL statement to be executed
Using the connection object

4 Data Adapter- The Shopper
Uses the connection object
Retrieves Items

5 Data set- The Pantry
Select- No Mod
Insert- creates a new record
Update- Edit
Delete

4 and 5 only used during the SELECT process

No comments:

Post a Comment