StoredProcedure Methods |
The StoredProcedure 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.
| |
Equals | Determines whether the specified object is equal to the current object. (Inherited from Object.) | |
Execute |
Executes the procedure.
| |
ExecuteNonQuery |
Executes a non query procedure (Insert, Update, Delete).
| |
Finalize | Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object.) | |
GetHashCode | Serves as a hash function for a particular type. (Inherited from Object.) | |
GetParameter |
Gets a parameter's value from the procedure.
| |
GetParamName |
Prepends a @ to the name of the parameter for use in SQL calls.
| |
GetType | Gets the Type of the current instance. (Inherited from Object.) | |
LogException |
Logs an exception to the event log.
| |
MemberwiseClone | Creates a shallow copy of the current Object. (Inherited from Object.) | |
ToString | Returns a string that represents the current object. (Inherited from Object.) |