'Declaration Public Property NumberMappings As OracleNumberMappingCollection
public OracleNumberMappingCollection NumberMappings {get; set;}
'Declaration Public Property NumberMappings As OracleNumberMappingCollection
public OracleNumberMappingCollection NumberMappings {get; set;}
Allows you to override default number mapping rules for the connection. Default value is an empty collection, which means to use default rules. Default rules are the following
| Precision | Scale | .NET type |
|---|---|---|
| 1 - 9 | 0 | System.Int32 |
| 10 - 15 | 0 | System.Double |
| > 15 | 0 | System.Decimal |
| 1 - 15 | > 0 | System.Double |
| > 15 | > 0 | System.Decimal |
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));
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))