In Hour 2, “Working with DataSets and DataTables,” you saw how to use a DataSet to represent your data. You saw how DataTables are analogous to tables in a database. In the last hour, you saw how to use the four major SQL query commands to work with data in a database.
In this hour, you'll learn
What a database relationship is
How to use a database relationship
How to use the Join operator
How to use the DataSet Relations collection to add a relationship between two DataSets
How to use the DataRelation to retrieve data