Migration from MS ADO to DevArt DataProvider
Posted: Fri 19 Nov 2010 09:40
Hi there,
we switched to .Net Framework 4.0 and since Microsoft will no longer support their ADO .NET Client for Oracle we are about to change to devart. I did some tests and had the following problem:
In our code there are statements like
OracleDataReader reader;
....
decimal? val = reader["field"] as decimal?
The field is defined as NUMBER(15) in oracle. The MS version works perfektly and the correct value is assigned to the val variable. When using the same code with the devart provider the assigned value is NULL because reader["field"] is a double. When using reader.GetDecimal(i) on that field I get the correct result.
Is there a known solution to use the given code above?
Regards
Samas
we switched to .Net Framework 4.0 and since Microsoft will no longer support their ADO .NET Client for Oracle we are about to change to devart. I did some tests and had the following problem:
In our code there are statements like
OracleDataReader reader;
....
decimal? val = reader["field"] as decimal?
The field is defined as NUMBER(15) in oracle. The MS version works perfektly and the correct value is assigned to the val variable. When using the same code with the devart provider the assigned value is NULL because reader["field"] is a double. When using reader.GetDecimal(i) on that field I get the correct result.
Is there a known solution to use the given code above?
Regards
Samas