ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Mapping Number(1,0) to Decimal in Entity Framework

880944Aug 8 2011 — edited May 31 2012

I have an SSDL which can work with either an Oracle or SQL Server DB. I had been using a trial Devart oracle driver and the Standard SQL server driver. All Number(1,0) fields are generated as Decimal. When I try to use the Oracle EF Beta 2 driver. I get the following error:

Oracle.msl(53,12) : error 2019: Member Mapping specified is not valid. The type 'Edm.Decimal[Nullable=False,DefaultValue=,Precision=1,Scale=0]' of member 'ISACTIVE' in type TESTModel.TBL_TEST' is not compatible with 'OracleEFProvider.number[Nullable=False,DefaultValue=,Precision=1,Scale=0]' of member 'ISACTIVE' in type 'Oracle.Store.TBL_TEST'.

Any ideas? I've tried adding the following to web.config:

<oracle.dataaccess.client>
<settings>
<add name="decimal" value="edmmapping number(1,0)" />
</settings>
</oracle.dataaccess.client>

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 28 2012

Added on Aug 8 2011

#odp-net

1 comment

2,323 views