StoredProcedure Class

An SQL Stored Procedure.

Inheritance Hierarchy

SystemObject
  Galactic.SqlStoredProcedure
    Galactic.Sql.MSSqlMSStoredProcedure
    Galactic.Sql.OracleOracleStoredProcedure

Namespace: Galactic.Sql
Assembly: Galactic.Sql (in Galactic.Sql.dll) Version: 1.3.0.499 (1.3.0.499)

Syntax

C++

Copy

public abstract class StoredProcedure : IExceptionLogger, 
	IStoredProcedure

Public MustInherit Class StoredProcedure
	Implements IExceptionLogger, IStoredProcedure

public ref class StoredProcedure abstract : IExceptionLogger, 
	IStoredProcedure

[<AbstractClassAttribute>]
type StoredProcedure =  
    class
        interface IExceptionLogger
        interface IStoredProcedure
    end

The StoredProcedure type exposes the following members.

Constructors

	Name	Description
	StoredProcedure	Initializes a new instance of the StoredProcedure class

Top

Properties

	Name	Description
	Command	The command to be sent to the database.
	Connection	The connection to the database.
	Log	The event log that will receive events from this logger.
	Name	The name of the stored procedure.

Top

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.
	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.)

Top

Fields

	Name	Description
	log	The event log that will receive events from this logger.

Top

Reference

Galactic.Sql Namespace