Devart Forums

When i add a table with the following definition

CREATE TABLE "TEST"
( "ID" NUMBER(19) NOT NULL ENABLE,
CONSTRAINT "TEST_PK" PRIMARY KEY ("ID")
)

in the model , the column ID is automatically mapped as 'Decimal' instead of 'Int64'

This seems to be working fine in Entity framework. The problem is happening only with LinqConnect.

LinqConnect uses the type returned by OracleDataReader. For Number(19) this is Decimal; we do not plan to change this behaviour, as this can affect compatibility with prior dotConnect for Oracle versions.

We are working on the possibility of configuring Oracle number mappings in the connection string, but cannot provide any timeframe for this. At the moment, a possible workaround is to set the needed type manually.

Thanks for clarifying..