ADO.NET Support for Larger Decimal Precision/Scale

Adaptive Server Enterprise ADO.NET Data Provider now supports AseDecimal - a structure that can support a precision/scale of 78.

Adaptive Server numeric and decimal datatypes support a maximum precision/scale of 38 and results from arithmetic operations can support precision/scale of up to 78, whereas the .NET Framework Decimal datatype can support a maximum precision/scale of 28. This can lead to data overflow when reading data of Adaptive Server numeric and decimal type or result of an arithmetic operation into the .NET Framework Decimal type.

Adaptive Server Enterprise ADO.NET Data Provider now supports AseDecimal - a structure that can support a precision/scale of 78. To use the AseDecimal structure to retrieve numeric or decimal values, set the new UseAseDecimal connection property to 1. By default, UseAseDecimal is set to 0 and the AseDecimal structure is not used.