|
The PsqlParameter object represents a parameter to an PsqlCommand object. The code examples include a code example that uses parameters.
Table 4-18 describes the public properties for PsqlParameter.
|
Property
|
Description
|
|---|---|
|
DbType
|
Gets or sets the DbType of the parameter.
|
|
Direction
|
Gets or sets a value that indicates whether the parameter is input-only, output-only, bidirectional, or the return value parameter of a stored procedure.
|
|
IsNullable
|
Gets or sets a value that indicates whether the parameter accepts null values.
|
|
ParameterName
|
Gets or sets the name of the data provider's Parameter object.
|
|
Precision
|
Gets or sets the maximum number of digits used to represent the Value property.
|
|
Scale
|
Gets or sets the number of decimal places to which Value is resolved.
|
|
Size
|
Gets or sets the maximum size, in bytes, of the data within the column.
|
|
SourceColumn
|
Gets or sets the name of the source column that is mapped to the DataSet and used for loading or returning the Value.
|
|
SourceVersion
|
Gets or sets the DataRowVersion to use when loading Value.
|
|
Value
|
Gets or sets the value of the parameter.
The initial default value is null.
Note: When array binding is enabled (see ArrayBindCount property of the PsqlCommand Object), this property is specified as an array of values. Each array's length must match the value of the ArrayBindCount property. When specifying the array's values for binary type columns, the data will actually be specified as byte[]. This is an array of arrays of bytes. The data provider anticipates a "jagged" array as such when using parameter array binding with parameters.
|
|
Chapter contents
Prev topic: PsqlInfoMessageEventArgs Object
|