Class QueryParameter

A parameter used in a sql query

Inheritance

object

QueryParameter

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Namespace: ETLBox.ControlFlow

Assembly: ETLBox.dll

Syntax

{{< /rawhtml >}} ```C# public class QueryParameter ``` {{< rawhtml >}}

Constructors

QueryParameter()

Declaration

{{< /rawhtml >}} ```C# public QueryParameter() ``` {{< rawhtml >}}

QueryParameter(object)

Declaration

{{< /rawhtml >}} ```C# public QueryParameter(object value) ``` {{< rawhtml >}}

Parameters

Type	Name	Description
object	value

QueryParameter(string, object)

Declaration

{{< /rawhtml >}} ```C# public QueryParameter(string name, object value) ``` {{< rawhtml >}}

Parameters

Type	Name	Description
string	name
object	value

QueryParameter(string, string, object)

Declaration

{{< /rawhtml >}} ```C# public QueryParameter(string name, string sqlType, object value) ``` {{< rawhtml >}}

Parameters

Type	Name	Description
string	name
string	sqlType
object	value

Properties

DbSize

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

Declaration

{{< /rawhtml >}} ```C# public int DbSize { get; } ``` {{< rawhtml >}}

Property Value

Type	Description
int

DbType

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

Declaration

{{< /rawhtml >}} ```C# public DbType? DbType { get; } ``` {{< rawhtml >}}

Property Value

Type	Description
DbType?

Name

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

Declaration

{{< /rawhtml >}} ```C# public string Name { get; set; } ``` {{< rawhtml >}}

Property Value

Type	Description
string

SqlType

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

Declaration

{{< /rawhtml >}} ```C# public string SqlType { get; set; } ``` {{< rawhtml >}}

Property Value

Type	Description
string

Value

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

Declaration

{{< /rawhtml >}} ```C# public object Value { get; set; } ``` {{< rawhtml >}}

Property Value

Type	Description
object