comparison key.

[hemantgaur]

is there a way to figure out which columns are going to be used for comparison, preferably in selectiondelegate implementation?

I am sure it must be stored somewhere before even comparison begins, i guess I am asking how do i access it runtime?

Thank you very much.

[Brian Donahue]

Hello,

If I understand you correctly, what you want to do is create a set of default mappings, then loop through each TableMapping and check the "Include" property on it, and in each of these loop through all of its' FieldMappings and see if they have the "Include" property set to true.

If a column could not be mapped, the "Include" property will be set to "false".
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521

[hemantgaur]

I am sorry. I should have been more clear. I meant primary key. What I meant to ask is out of all the columns that I am comparing what amongst those are the part of the primary key.

Thank you.

[Brian Donahue]

Hello,

Each TableMapping has a MatchingMappings property -- this is a collection of Fields that make up the comparison key, whether the mapping was created automatically or you created it yourself.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521