Sams Teach Yourself ADO.NET in 24 Hours

Q&A

Q1:

Is it possible to still use regular join operations with the dataset?

A1:

Yes, in fact you will still use joins in your database queries to retrieve data. Retrieving data first into DataSets, setting up relationships, and then navigating the relationships is much slower than simply using a join operation and letting your data source assemble the records for you. However, there are many instances (such as the case with varying data sources) where the DataRelation object comes in very handy.