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 with a parameter IDbCommand object to build the collection

Inheritance
Object
SoSqlParameter
Namespace: SuperOffice.Data
Assembly: SoDataBase.dll
Syntax
public class SoSqlParameter : Object

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