 | MSStoredProcedure Class |
An SQL Stored Procedure.
Inheritance HierarchyNamespace: Galactic.Sql.MSSql
Assembly: Galactic.Sql.MSSql (in Galactic.Sql.MSSql.dll) Version: 1.3.0.499 (1.3.0.499)
SyntaxThe MSStoredProcedure type exposes the following members.
Constructors| Name | Description | |
|---|---|---|
 | MSStoredProcedure |
Creates a stored procedure.
|
Properties| Name | Description | |
|---|---|---|
 | Command |
The command to be sent to the database.
(Overrides StoredProcedureCommand.) |
| Connection |
The connection to the database.
(Overrides StoredProcedureConnection.) |
| Log |
The event log that will receive events from this logger.
(Inherited from StoredProcedure.) |
| Name |
The name of the stored procedure.
(Inherited from StoredProcedure.) |
Methods| Name | Description | |
|---|---|---|
| AddBooleanParameter |
Adds a boolean parameter to the procedure.
(Overrides StoredProcedureAddBooleanParameter(String, NullableBoolean, StoredProcedureParameterType).) |
| AddDateTimeParameter |
Adds a date and time parameter to the procedure.
(Overrides StoredProcedureAddDateTimeParameter(String, DateTime, StoredProcedureParameterType).) |
| AddInt32Parameter |
Adds a 32-bit integer parameter to the procedure.
(Overrides StoredProcedureAddInt32Parameter(String, NullableInt32, StoredProcedureParameterType).) |
| AddInt64Parameter |
Adds a 64-bit integer parameter to the procedure.
(Overrides StoredProcedureAddInt64Parameter(String, NullableInt64, StoredProcedureParameterType).) |
| AddNCharParameter |
Adds an Unicode fixed length character parameter to the procedure.
Strings longer than SqlUtility.MAX_NCHAR_LENGTH and the length argument are truncated to fit.
(Overrides StoredProcedureAddNCharParameter(String, String, Int32, StoredProcedureParameterType).) |
| 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.
(Overrides StoredProcedureAddNVarCharParameter(String, String, Int32, StoredProcedureParameterType).) |
| AddParameter |
Adds a parameter to the procedure.
(Inherited from StoredProcedure.) |
| 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.
(Overrides StoredProcedureAddVarCharParameter(String, String, Int32, StoredProcedureParameterType).) |
| Equals | Determines whether the specified object is equal to the current object. (Inherited from Object.) |
| Execute |
Executes the procedure.
(Inherited from StoredProcedure.) |
| ExecuteNonQuery |
Executes a non query procedure (Insert, Update, Delete).
(Inherited from StoredProcedure.) |
 | 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.
(Overrides StoredProcedureGetParameter(String).) |
| GetParamName |
Prepends a @ to the name of the parameter for use in SQL calls.
(Overrides StoredProcedureGetParamName(String).) |
| GetType | Gets the Type of the current instance. (Inherited from Object.) |
| LogException |
Logs an exception to the event log.
(Inherited from StoredProcedure.) |
| MemberwiseClone | Creates a shallow copy of the current Object. (Inherited from Object.) |
| ToString | Returns a string that represents the current object. (Inherited from Object.) |
Fields| Name | Description | |
|---|---|---|
 | log |
The event log that will receive events from this logger.
(Inherited from StoredProcedure.) |
  | MAX_NVARCHAR_SIZE |
The value for MAX sized nvarchar parameters.
Used to create nvarchar parameter values of greater than MSSqlUtility.MAX_NVARCHAR_LENGTH.
|
| MAX_VARCHAR_SIZE |
The value for MAX sized varchar parameters.
Used to create nvarchar parameter values of greater than MSSqlUtility.MAX_VARCHAR_LENGTH.
|
See Also