|DbType||"DbType" is the database type. This input is usually loaded from configuration variables.|
|ConnectionString||"ConnectionString" is the connection string to the database. This input is usually loaded from configuration variables.|
|FileName||"FileName" is the name of the database table on which we would like to run the delete.|
|Keys||The Keys create the WHERE Clause of the query. The keys are concatenated to form the following pattern:
The AndOr values determine the order in which the keys are run. ANDs are always evaluated before ORs. This is similar to the way a BinaryDecision service works.
This is the container node that contains all the Key nodes. It does not accept any input, but you can Right-Click to add new Keys (Key#0, Key#1, etc.). Each Key below this node is built into the query as a Where Clause.|
|AndOr||"AndOr" is used when we are dealing with more than one key. Valid values are "And" and "Or". If this value is left blank it defaults to "And".
The AndOr values determine the order in which the keys are run. ANDs are always evaluated before ORs.|
|Column||The column to be referenced from the table in the query.|
|Operator||The operator to be used in the Key.|
|Type||This is the data type of the "Value". This determines whether the "Value" is encased in single quotes.|
|Value||the value which we will compare against the "Column" of the this Key.|
|CommandTimeout||"CommandTimeout" is the timeout for query in milliseconds. After this time the service cancels execution of the query and throws an error.|