NavigationPropertyNameGenerator's Relationship Details SingleTarget Field

[Ben-Dev]

Hello,

Sql.Database's option NavigationPropertyNameGenerator, if set, is expected to be set to a callback function. When invoked, this function is passed two arguments, the second of which is a list of records describing the various relationships that need a relationship column name generated.

Each of these records is in the shape of:

[
  SourceTableName = text,
  SourceKeys = {text},
  TargetTableName = text,
  TargetKeys = {text},
  SingleTarget = logical
]

What does the "SingleTarget" field signify? In my testing, it's always set to true.

Thank you,
Ben

[rufengli]

Hi, @Ben-Dev ,

You should always set it to true.  The "false" option is needed for backward combatility and does not apply to SQL connector.

[Ben-Dev]

Hi rufengli,

Thanks, but this isn't an option I can set. 🙂 It's in data provided to me when the callback function is invoked by Microsoft code.

Maybe it would help if I asked the question this way: Will the values of SingleTarget that are passed to my NavigationPropertyNameGenerator callback always be set to true, regardless of the data connector being used?

Thanks,

Ben

[rufengli · Accepted solution]

You can expect it always is set to true (unless you used MySql connector and created the report years ago).

[Ben-Dev]

Thank you, @rufengli!