Click or drag to resize
Galactic API

MSStoredProcedure Class

An SQL Stored Procedure.
Inheritance Hierarchy

Namespace:  Galactic.Sql.MSSql
Assembly:  Galactic.Sql.MSSql (in Galactic.Sql.MSSql.dll) Version: 1.3.0.499 (1.3.0.499)
Syntax
public class MSStoredProcedure : StoredProcedure

The MSStoredProcedure type exposes the following members.

Constructors
  NameDescription
Public methodMSStoredProcedure
Creates a stored procedure.
Top
Properties
  NameDescription
Public propertyCommand
The command to be sent to the database.
(Overrides StoredProcedureCommand.)
Public propertyConnection
The connection to the database.
(Overrides StoredProcedureConnection.)
Public propertyLog
The event log that will receive events from this logger.
(Inherited from StoredProcedure.)
Public propertyName
The name of the stored procedure.
(Inherited from StoredProcedure.)
Top
Methods
  NameDescription
Public methodAddBooleanParameter
Adds a boolean parameter to the procedure.
(Overrides StoredProcedureAddBooleanParameter(String, NullableBoolean, StoredProcedureParameterType).)
Public methodAddDateTimeParameter
Adds a date and time parameter to the procedure.
(Overrides StoredProcedureAddDateTimeParameter(String, DateTime, StoredProcedureParameterType).)
Public methodAddInt32Parameter
Adds a 32-bit integer parameter to the procedure.
(Overrides StoredProcedureAddInt32Parameter(String, NullableInt32, StoredProcedureParameterType).)
Public methodAddInt64Parameter
Adds a 64-bit integer parameter to the procedure.
(Overrides StoredProcedureAddInt64Parameter(String, NullableInt64, StoredProcedureParameterType).)
Public methodAddNCharParameter
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).)
Public methodAddNVarCharParameter
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).)
Public methodAddParameter
Adds a parameter to the procedure.
(Inherited from StoredProcedure.)
Public methodAddVarCharParameter
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).)
Public methodEquals
Determines whether the specified object is equal to the current object.
(Inherited from Object.)
Public methodExecute
Executes the procedure.
(Inherited from StoredProcedure.)
Public methodExecuteNonQuery
Executes a non query procedure (Insert, Update, Delete).
(Inherited from StoredProcedure.)
Protected methodFinalize
Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection.
(Inherited from Object.)
Public methodGetHashCode
Serves as a hash function for a particular type.
(Inherited from Object.)
Public methodGetParameter
Gets a parameter's value from the procedure.
(Overrides StoredProcedureGetParameter(String).)
Public methodGetParamName
Prepends a @ to the name of the parameter for use in SQL calls.
(Overrides StoredProcedureGetParamName(String).)
Public methodGetType
Gets the Type of the current instance.
(Inherited from Object.)
Public methodLogException
Logs an exception to the event log.
(Inherited from StoredProcedure.)
Protected methodMemberwiseClone
Creates a shallow copy of the current Object.
(Inherited from Object.)
Public methodToString
Returns a string that represents the current object.
(Inherited from Object.)
Top
Fields
  NameDescription
Protected fieldlog
The event log that will receive events from this logger.
(Inherited from StoredProcedure.)
Public fieldStatic memberMAX_NVARCHAR_SIZE
The value for MAX sized nvarchar parameters. Used to create nvarchar parameter values of greater than MSSqlUtility.MAX_NVARCHAR_LENGTH.
Public fieldStatic memberMAX_VARCHAR_SIZE
The value for MAX sized varchar parameters. Used to create nvarchar parameter values of greater than MSSqlUtility.MAX_VARCHAR_LENGTH.
Top
See Also