IStoredProcedure Methods |
The IStoredProcedure type exposes the following members.
Name | Description | |
---|---|---|
AddBooleanParameter |
Adds a boolean parameter to the procedure.
| |
AddDateTimeParameter |
Adds a date and time parameter to the procedure.
| |
AddInt32Parameter |
Adds a 32-bit integer parameter to the procedure.
| |
AddInt64Parameter |
Adds a 64-bit integer parameter to the procedure.
| |
AddNCharParameter |
Adds an Unicode fixed length character parameter to the procedure.
Strings longer than SqlUtility.MAX_NVARCHAR_LENGTH and the length argument are truncated to fit.
| |
AddNVarCharParameter |
Adds an Unicode variable character parameter to the procedure.
Strings longer than SqlUtility.MAX_NVARCHAR_LENGTH and the length argument are truncated to fit.
| |
AddParameter |
Adds a parameter to the procedure.
| |
AddVarCharParameter |
Adds an Non-Unicode variable character parameter to the procedure.
Strings longer than SqlUtility.MAX_VARCHAR_LENGTH and the length argument are truncated to fit.
| |
Execute |
Executes the procedure.
| |
ExecuteNonQuery |
Executes a non query procedure (Insert, Update, Delete).
| |
GetParameter |
Gets a parameter's value from the procedure.
| |
GetParamName |
Prepends a @ to the name of the parameter for use in SQL calls.
|