|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.|
|Query||"Query" is the query we would like to execute.|
|Parameters||These are Parameters that are built by EASYProcess with the given input for each Parameter node.
This is the container node that contains all the Parameter nodes. It does not accept any input, but you can Right-Click to add new Parameters (Parameter#0, Parameter#1, etc.). Each Parameter below this node can be used in our query.|
|Parameter||There must be a "@[Name]" existing somewhere in the "Query" which matches the assigned name of the parameter in order for EASYProcess to know where in the query this parameter must be placed.
"Parameter" is a container node which accepts no input but represents a single Parameter that can contain Name, Value and DataType of the Parameter. Each Parameter node is indexed.|
|Name||"Name" is the name we would like to assign to the parameter.|
|Value||"Value" is the value we would like to assign to the parameter.|
|DataType||This is the data type of the "Value". This determines whether the "Value" is encased in single quotes.|
|ParametersXml||"ParametersXml" is where we can pass parameters in XML format instead of through the EASYProcess-built parameters. This must have the following format:
|CommandTimeout||"CommandTimeout" is the timeout for query in milliseconds. After this time the service cancels execution of the query and throws an error.|