12. Understanding .NET Data Provider Connectivity : .NET Data Provider Classes : IngresParameter Class : IngresParameter Class Properties
 
Share this page                  
IngresParameter Class Properties
The properties for the IngresParameter are:
Property
Accessor
Description
DbType
get set
The type that the parameter must be converted to before being passed to the database server. Setting this parameter induces a setting of IngresType property.
Default is DbType.String.
Direction
get set
Indicators whether the parameter has an input, input/output, output, or procedure return value.
IngresType
get set
The type that the parameter must be converted to before being passed to the database server. Setting this parameter induces a setting of DbType property.
Default is IngresType.NvarChar if the database supports Unicode UTF-16; otherwise the default is IngresType.VarChar.
IsNullable
get set
Indicates whether the parameter accepts null values.
True = accepts null values. False = does not accept null values.
ParameterName
get set
The name of the parameter.
Default is “”.
Precision
get set
Maximum number of digits for decimal parameters.
Default is 0.
Scale
get set
Number of decimal places for decimal parameters.
Default is 0.
Size
get set
Maximum size of binary and string data to be sent to the server.
Default is inferred from the parameter value.
SourceColumn
get set
The name of the source column mapped to a DataSet.
Default is “”.
SourceVersion
get set
The DataRowVersion used by an UpdateCommand during an Update operation for setting the parameter.
Default is DataRowVersion.Current.
Value
get set
The value of the parameter.
Default is null.
Important!  .NET strings are Unicode based. If the application is sending a Unicode string as a parameter to a database field that is ASCII char or varchar, the application can direct the data provider to coerce the Unicode string to an ASCII string on the client side by setting the parameter DbType property to DbType.AnsiString, or the IngresType property to IngresType.VarChar.