StrataFrame Forum » StrataFrame Application Framework - V1 » Business Objects and Data Access (How do I?) » Relating on non primary key

Relating on non primary key

Ian Johnston — Thu, 21 Oct 2010 13:31:41 GMT

I am importing lagacy data. I have imported the data using sqlBulkCopy the old data priamry key is a random number entered by the user so they are all over the place. The new tables auto generate the primary keys. I heed to link te two tables on a field containing the old primary key so that I can update the FK with the new PK. I have been looking at the BusinessLayerLinkManager but am not getting anywhere. Is that the way I should be doing this?

RE: Relating on non primary key

Ivan George Borges — Thu, 21 Oct 2010 13:31:41 GMT

Glad it helped, Ian. :cool:

RE: Relating on non primary key

Ian Johnston — Thu, 21 Oct 2010 12:55:46 GMT

This is a one time migration operation. Got it working using Ivan's suggestion.

RE: Relating on non primary key

Ian Johnston — Thu, 21 Oct 2010 12:53:51 GMT

Thanks for the input, got it working using a lookup on th old key and returning the new one.

RE: Relating on non primary key

Greg McGuffey — Wed, 20 Oct 2010 14:48:17 GMT

Ian, is this a data migration task (i.e. you're doing it or writing a script to handle it one time) or is this something the users need to do as part of normal use of the app?

RE: Relating on non primary key

Ivan George Borges — Wed, 20 Oct 2010 13:46:30 GMT

Hi Ian.

If I understand what you need, you have a Parent and a Child imported from a legacy database and want to update the Child foreign key with the new Parent PK, is that so? I guess you have the value of the old Parent "primary key" stored in some field in your table, so you could create a Fill Method on your Child table that woud take the Parent table old "primary key" as a parameter and then write the SQL Server statement to fill your Child BO with that(those) record(s) and then change any field contents you would like.