Add(OracleNumberType,Int32,Int32,Type) Method

On this page

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

Syntax

Visual Basic
C#


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

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


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

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));

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))

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