Promote Db Query Result - Context Property Value Exists

Source	https://github.com/BizTalkComponents/PromoteDbQueryResult
NuGet package	https://www.nuget.org/packages/BizTalkComponents.PipelineComponents.PromoteDbQueryResult.ContextPropertyValueExists/
Download installer

Usage

Promotes True in the specified output context property if the input context property 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.

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.
InputPropertyPath	Required	The input context property.
OutputPropertyPath	Required	The output context property path holding the result from the database query.

Throws ArgumentException if any of the required parameters is not specified.