O'Reilly logo

Essential ADO.NET by Bob Beauchemin

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

B.5. Parent/Child Relation Referencing

A column in a child table may be referenced in an expression by prepending the column name with “Child.” For example, “Child.Price” would reference the column named Price in the child table.

If a table has more than one child, the syntax is: Child(RelationName). For example, if a table has two child tables named Employee and Titles, and the Data-Relation objects are named “Publishers2Employee: and “Publishers2Titles,” the reference would be:

Child(Publishers2Employee).fname
Child(Publishers2Titles).title

A parent table may be referenced in an expression by prepending the column name with “Parent.” For example, the “Parent.Price” references the parent table's column named “Price.”

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