Click or drag to resize
Galactic API

StoredProcedureAddParameter Method

Adds a parameter to the procedure.

Namespace:  Galactic.Sql
Assembly:  Galactic.Sql (in Galactic.Sql.dll) Version: 1.3.0.499 (1.3.0.499)
Syntax
public bool AddParameter(
	string name,
	Object value,
	DbType valueType,
	Type parameterType,
	StoredProcedureParameterType direction,
	Nullable<int> maxSize = null
)

Parameters

name
Type: SystemString
The name of the parameter to add.
value
Type: SystemObject
The value of the parameter to add.
valueType
Type: System.DataDbType
The database type of the value to add with the parameter.
parameterType
Type: SystemType
The object type of the parameter. Must be dervied from System.Data.Common.DbParameter.
direction
Type: Galactic.SqlStoredProcedureParameterType
The direction of the parameter. Use one of the class parameter constants. Defaults to IN.
maxSize (Optional)
Type: SystemNullableInt32
The maximum size of the parameter's value in bytes (if relevant).

Return Value

Type: Boolean
True if the parameter is added, false otherwise.

Implements

IStoredProcedureAddParameter(String, Object, DbType, Type, StoredProcedureParameterType, NullableInt32)
See Also