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