ETLBox
Title here
Summary here
QueryParameter
Class QueryParameter
A parameter used in a sql query
Inherited Members
Namespace: ETLBox.ControlFlow
Assembly: ETLBox.dll
Syntax
public class QueryParameterConstructors
QueryParameter()
Declaration
public QueryParameter()QueryParameter(object)
Declaration
public QueryParameter(object value)Parameters
| Type | Name | Description |
|---|---|---|
| object | value |
QueryParameter(string, object)
Declaration
public QueryParameter(string name, object value)Parameters
| Type | Name | Description |
|---|---|---|
| string | name | |
| object | value |
QueryParameter(string, string, object)
Declaration
public QueryParameter(string name, string sqlType, object value)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
public int DbSize { get; }Property Value
| Type | Description |
|---|---|
| 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
| Type | Description |
|---|---|
| DbType? |
Name
Name of the parameter in the query (e.g. "Par1")
Declaration
public string Name { get; set; }Property Value
| Type | Description |
|---|---|
| string |
SqlType
The database specific sql column type string (e.g. "INT" or "VARCHAR(100)"
Declaration
public string SqlType { get; set; }Property Value
| Type | Description |
|---|---|
| string |
Value
The value of the parameter - null will be converted into a DBNull.Value
Declaration
public object Value { get; set; }Property Value
| Type | Description |
|---|---|
| object |
Next
RecoveryModel