Add(OracleNumberType,Int32,Int32,Type) Method

In This Topic

Syntax
Example
See Also

Creates a new instance of the OracleNumberMapping class and adds it to the collection.

Syntax

Visual Basic
C#

public OracleNumberMapping Add( 
   OracleNumberType numberType,
   int fromPrecision,
   int toPrecision,
   Type valueType
)

'Declaration
 
Public Overloads Function Add( _
   ByVal numberType As OracleNumberType, _
   ByVal fromPrecision As Integer, _
   ByVal toPrecision As Integer, _
   ByVal valueType As Type _
) As OracleNumberMapping

Parameters

numberType: The Oracle number type being mapped.
fromPrecision: The minimal precision of Oracle number for which it should be mapped to the specified .NET type.
toPrecision: The maximal precision of Oracle number for which it should be mapped to the specified .NET type.
valueType: The .NET type to which the Oracle number is mapped.

Return Value

The created OracleNumberMapping object.

Example

This sample demonstrates how to override default number mapping rules for the connection.

csharp

OracleConnection oracleConnection = new OracleConnection();

// Map NUMBER(10)..NUMBER(18)  to Int64
oracleConnection.NumberMappings.Add(OracleNumberType.Integer, 10, 18, typeof(Int64)); 

// Map NUMBER(1)  to Boolean
oracleConnection.NumberMappings.Add(OracleNumberType.Integer, 1, typeof(bool));

Visual Basic

Dim oracleConnection as New OracleConnection

' Map NUMBER(10)..NUMBER(18)  to Int64
oracleConnection.NumberMappings.Add(OracleNumberType.Integer, 10, 18, GetType(Int64))

' Map NUMBER(1)  to Boolean
oracleConnection.NumberMappings.Add(OracleNumberType.Integer, 1, GetType(Boolean))

Reference

OracleNumberMappingCollection Class
OracleNumberMappingCollection Members
Overload List

Send Feedback