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.”
Get Essential ADO.NET now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
