Promote Db Query Result - xPath Value Exists
| Source | https://github.com/BizTalkComponents/PromoteDbQueryResult |
| NuGet package | https://www.nuget.org/packages/BizTalkComponents.PipelineComponents.PromoteDbQueryResult.XPathValueExists/ |
| Download installer |
Usage
Promotes True in the specified output context property if the input xPath value exists in the database, False otherwise.
This component is useful when you need to promote whether a value exists or not in a database.
Properties
| DbColumnName | Required | The name of the database column to check the input context property value against. |
| DbColumnType | Required | The type of the database column, Int/String. |
| DbConnectionString | Required | The database connection string. |
| DbProvider | Required | The database provider. |
| DbTableName | Required | The name of the database table. |
| InputXPath | Required | The input xPath. |
| OutputPropertyPath | Required | The output context property path holding the result from the database query. |
Remarks
Throws ArgumentException if any of the required parameters is not specified.