April 2003
Beginner to intermediate
620 pages
21h 48m
English
Content preview from ADO.NET in a NutshellBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Chapter 11. DataRelations
Chapter 10
showed how to
use ForeignKeyConstraint rules to help ensure the
integrity of relational data. Though
ForeignKeyConstraint objects are important for
data validation, they don’t provide any benefit when
it comes to navigating the DataSet. For example,
even if you define a link between two tables with a
ForeignKeyConstraint, you can’t
use this link to create a master-detail list.
ADO.NET provides another object that can help in this situation: the
DataRelation. You can use a
DataRelation to automatically generate and apply a
ForeignKeyConstraint, or you can use it simply as
a navigational aid. The benefit of the
DataRelation is that it allows you to navigate
disconnected data using a defined relationship between tables. For
example, if you select a single parent row, you can use the
DataRelation to retrieve a list of child records.
Conversely, you can use the DataRelation to
discover the parent of any child row.
This chapter explains how to create a
DataRelation, use it for
record
navigation, and build a master-detail list.
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.