topic Re: Populate relationship class without using OIDs? in ArcObjects SDK Questions

Populate relationship class without using OIDs?

JohnFannon — Thu, 05 Jan 2012 12:23:27 GMT

Hi

We have a M-M relationship class (with an intermediate table) and can only find documentation on populating this using origin and destination OIDs through IRelationshipClass.CreateRelationship.

The relationship class origin and destination primary and foreign keys are NOT using objectID, but another field within the tables. I would like if possible to populate the relationship using values from these fields instead of objectIDs.

Anyone know if this is possible and if there are any examples? I can't find many decent examples for populating relationship classes.

Cheers

John

Re: Populate relationship class without using OIDs?

sapnas — Fri, 13 Jan 2012 20:48:16 GMT

Have you tried using IMemoryRelationshipClassFactory? Check out the below link for the sample code
http://help.arcgis.com/en/sdk/10.0/arcobjects_net/componenthelp/index.html#//002500000n8v000000

Re: Populate relationship class without using OIDs?

JohnFannon — Wed, 01 Feb 2012 12:21:30 GMT

For reference - I've managed to find a way to do this.

As the relationship class is m-m and therefore the relationship has an intermediate table, I can query interface to get an ITable from the IRelationshipClass and then simply insert new relationships using ITable methods such as CreateRow(), SetValue() and Store(). As I thought, this performs much better than IRelationshipClass.CreateRelationship.

Hope that helps someone else out.

John