QueryParameter

Class QueryParameter

A parameter used in a sql query

Inheritance
QueryParameter
Namespace: ETLBox.ControlFlow
Assembly: ETLBox.dll
Syntax
    public class QueryParameter

Constructors

QueryParameter()

Declaration
    public QueryParameter()

QueryParameter(object)

Declaration
    public QueryParameter(object value)
Parameters
TypeNameDescription
objectvalue

QueryParameter(string, object)

Declaration
    public QueryParameter(string name, object value)
Parameters
TypeNameDescription
stringname
objectvalue

QueryParameter(string, string, object)

Declaration
    public QueryParameter(string name, string sqlType, object value)
Parameters
TypeNameDescription
stringname
stringsqlType
objectvalue

Properties

DbSize

The database column size parsed from the sql column type (e.g. "VARCHAR(100)" return 100)

Declaration
    public int DbSize { get; }
Property Value
TypeDescription
int

DbType

The database column type parsed from the sql column type (e.g. "VARCHAR(100)" return DbType.String

Declaration
    public DbType? DbType { get; }
Property Value
TypeDescription
DbType?

Name

Name of the parameter in the query (e.g. "Par1")

Declaration
    public string Name { get; set; }
Property Value
TypeDescription
string

SqlType

The database specific sql column type string (e.g. "INT" or "VARCHAR(100)"

Declaration
    public string SqlType { get; set; }
Property Value
TypeDescription
string

Value

The value of the parameter - null will be converted into a DBNull.Value

Declaration
    public object Value { get; set; }
Property Value
TypeDescription
object