In Hour 2, "Working with DataSets and DataTables," you saw how to use a DataSet to represent your data. You saw how DataTable s 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.
This hour extends the concepts in both Hour 2 and Hour 3 by first discussing database relationships, and then by showing how to create these relationships in a DataSet .
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 DataSet s
How to use the DataRelation to retrieve data