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.