We are having issue with consuming the numeric data through odata service in c# code.
We have page metadata with numeric field and if the length of the number specified in that field goes beyond 6 then odata returns data in exponential format. So 60135752 is returned as 6.0135752E7.
When trying to read this data through c# code, I am getting error:
Cannot convert a primitive value to the expected type 'Edm.Decimal'.
Has anybody faced similar issue? Any help is appreciated.
Note: I have verified that package and database have the data in non-exponential format, it is only when I retrieve it through Odata, I am getting it in exponential format.