SiebelParameter class in the Siebel adapter

The Data Provider for Siebel provides a DbParameter implementation to enable an ADO.NET client to specify parameters for a particular command. Using an instance of the System.Data.Common.DbCommand class of the Data Provider for Siebel, a client program can obtain an instance of the System.Data.Common.DbParameter class.

//In this example, command is an instance of DbCommand  
DbParameter param = command.CreateParameter();  

Alternatively, the following approach can be used:


//Here command is an instance of SiebelCommand  
SiebelParameter param = (SiebelParameter) command.CreateParameter();                  
param.ParameterName = "@Time";  

The SiebelParameter class inherits from DbParameter. It exists in the namespace Microsoft.Data.SiebelClient.

Supported Properties

The SiebelParameter class supports the following DbParameterpublic properties:

Name Get/Set Description
DbType Get and Set Data type of the parameter. See Basic Siebel Data Types.
Direction Get and Set The following values are supported:

- ParameterDirection.Input

- ParameterDirection.Output

- ParameterDirection.InputOutput
IsNullable Get and Set The property is not supported, and will throw an exception if called.
ParameterName Get and Set The Data Provider for Siebel supports this property for an ADO.NET client to specify the parameter name.
Value Get and Set The Data Provider for Siebel represents parameter values as strings.

Supported Data Types

The following table summarizes the simple Siebel field types that Data Provider for Siebel supports. For more detailed coverage, see Basic Siebel Data Types.

Siebel Field Type .NET Type XML Schema Type
DTYPE_BOOL Boolean xsd:boolean
DTYPE_CURRENCY Decimal xsd:decimal
DTYPE_DATE DateTime xsd:dateTime
DTYPE_DATETIME DateTime xsd:dateTime
DTYPE_ UTCDATETIME DateTime xsd:dateTime
DTYPE_ID String xsd:string
DTYPE_INTEGER Integer xsd:int
DTYPE_NOTE String xsd:string
DTYPE_NUMBER Decimal xsd:decimal
DTYPE_PHONE String xsd:string
DTYPE_TEXT String xsd:string
DTYPE_TIME DateTime xsd:dateTime

Supported Methods

The SiebelParameter class does not override any special methods in DbParameter.

See Also

Extend ADO.NET Interfaces with the Siebel adapter