SqlInputOptions interface
Properties
command |
The Transact-SQL query command or name of the stored procedure executed by the binding. |
command |
The command type value |
connection |
An app setting (or environment variable) with the connection string for the database against which the query or stored procedure is being executed |
parameters | Zero or more parameter values passed to the command during execution as a single string. Must follow the format @param1=param1,@param2=param2. Neither the parameter name nor the parameter value can contain a comma (,) or an equals sign (=). |
Property Details
commandText
The Transact-SQL query command or name of the stored procedure executed by the binding.
commandText: string
Property Value
string
commandType
The command type value
commandType: "Text" | "StoredProcedure"
Property Value
"Text" | "StoredProcedure"
connectionStringSetting
An app setting (or environment variable) with the connection string for the database against which the query or stored procedure is being executed
connectionStringSetting: string
Property Value
string
parameters
Zero or more parameter values passed to the command during execution as a single string. Must follow the format @param1=param1,@param2=param2. Neither the parameter name nor the parameter value can contain a comma (,) or an equals sign (=).
parameters?: string
Property Value
string