O'Reilly logo

Sams Teach Yourself ADO.NET in 24 Hours by Paul Bertucci, Jason Lefebvre

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

The DataRelation Object

As you've seen in Hour 2, “Working with DataSets and DataTables,” the ADO.NET DataSet object can almost precisely mirror data returned from the data source. This includes all the data relations and constraints present in the database as well as the data itself!

In other words, within the DataSet itself, you can create relationships, just like the ones you saw earlier inside SQL Server. After the relationships are set up, you can retrieve relationship-based information without having to write a database query.

New Functionality with the DataSet!

In addition to giving you great power and flexibility when working with data retrieved ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required