GGC: Finding column descriptors added by ForeignKeyReference relation

[Sigurd Ringbakken]

When adding a ForeignKeyReference relation to a table descriptor, the table is extended with columns from the child table. The columns are prefixed with the name of the relation descriptor. Is there an easy way to find these column descriptors?

[Daniel Jebaraj]

Test. Please ignore update.

>When adding a ForeignKeyReference relation to a table descriptor, the table is extended with columns from the child table. The columns are prefixed with the name of the relation descriptor. Is there an easy way to find these column descriptors?

[Administrator]

Hi Sigurd,

you can loop through all the columns of the related table when you access the ChildTableDescriptor of the RelationDesriptor, e.g. in the ForeignKeyReference example:

this.gridGroupingControl1.DataSource = table;

mainTd.Name = "ForeignKeyReference";

mainTd.Columns.LoadDefault();

foreach (RelationDescriptor rd in mainTd.Relations)

{

if (rd.RelationKind == RelationKind.ForeignKeyReference)

{

foreach (FieldDescriptor fd in rd.ChildTableDescriptor.Fields)

{

string name = countriesRd.Name + "_" + fd.Name;

GridColumnDescriptor cd = mainTd.Columns.FindByMappingName(name);

if (cd != null)

Console.WriteLine(cd.Name);

}

}

}

Stefan

>When adding a ForeignKeyReference relation to a table descriptor, the table is extended with columns from the child table. The columns are prefixed with the name of the relation descriptor. Is there an easy way to find these column descriptors?

[Sigurd Ringbakken]

>you can loop through all the columns of the related table when you access the ChildTableDescriptor of the RelationDesriptor, e.g. in the ForeignKeyReference example:

Yes, but I was hoping I could avoid that and rather find them in a collection somewhere.