C# and the Oracle Number Datatype

Question

I need to read a value from an Oracle database and the field has been declared as Number(38). How can I do this in C# since the Decimal type isn't big enough?

Answer 1

You could call GetString(ordinal) on the data reader, and feed the result to System.Numerics.BigInteger.TryParse().

Or perhaps you could leave the value in the OracleDecimal datatype, like you received it from ODP.NET. OracleDecimal has functions for almost everything, including math: Mulitply, Round, Exp, and so on.