Class SoSqlParameter

Base class The purpose of this class is to return arguments to a sqlcommand. It contains a generated sql query and a collection of SoParameter. In order to create a command parametercollection the class uses SoSqlParameter.AddParametersToCommand with a parameter IDbCommand object to build the collection

Inheritance

object

SoSqlParameter

Inherited Members

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

Namespace: SuperOffice.Data

Assembly: SoDataBase.dll

Syntax

public class SoSqlParameter

Fields

_parameterCollection

Base class The purpose of this class is to return arguments to a sqlcommand. It contains a generated sql query and a collection of SoParameter. In order to create a command parametercollection the class uses SoSqlParameter.AddParametersToCommand with a parameter IDbCommand object to build the collection

Declaration

protected ArrayList _parameterCollection

Field Value

Type	Description
ArrayList

_sql

Base class The purpose of this class is to return arguments to a sqlcommand. It contains a generated sql query and a collection of SoParameter. In order to create a command parametercollection the class uses SoSqlParameter.AddParametersToCommand with a parameter IDbCommand object to build the collection

Declaration

protected string _sql

Field Value

Type	Description
string

Methods

CreateParameter(string, FieldDataType)

Base class The purpose of this class is to return arguments to a sqlcommand. It contains a generated sql query and a collection of SoParameter. In order to create a command parametercollection the class uses SoSqlParameter.AddParametersToCommand with a parameter IDbCommand object to build the collection

Declaration

protected virtual IDbDataParameter CreateParameter(string parameterName, FieldDataType fieldDataType)

Parameters

Type	Name	Description
string	parameterName
FieldDataType	fieldDataType

Returns

Type	Description
IDbDataParameter

CreateParameter(string, object)

Base class The purpose of this class is to return arguments to a sqlcommand. It contains a generated sql query and a collection of SoParameter. In order to create a command parametercollection the class uses SoSqlParameter.AddParametersToCommand with a parameter IDbCommand object to build the collection

Declaration

protected virtual IDbDataParameter CreateParameter(string parameterName, object value)

Parameters

Type	Name	Description
string	parameterName
object	value

Returns

Type	Description
IDbDataParameter

Extension Methods

EnumUtil.MapEnums<From, To>(From)

Converters.MapEnums<From, To>(From)