 | IStoredProcedure Interface |
An Interface for SQL Stored Procedures.
Namespace: Galactic.Sql
Assembly: Galactic.Sql (in Galactic.Sql.dll) Version: 1.3.0.499 (1.3.0.499)
SyntaxThe IStoredProcedure type exposes the following members.
Properties| Name | Description | |
|---|---|---|
 | Command |
The command to be sent to the database.
|
| Connection |
The connection to the database.
|
| Name |
The name of the stored procedure.
|
Methods| 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.
|
See Also