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