oracle - Type inacurracy -
i'm trying create entity data model
using visual studio 2012 , oracle 10g. i'm getting error:
error 1 running transformation: types of properties in dependent role of referential constraint must same corresponding property types in principal role. type of property 'quartal_sec_id' on entity 'model.quartal' not match type of property 'sec_id' on entity 'model.sec' in referential constraint 'fk_quartal_sec_id'.
indeed sec_id
has number(32)
, quartal_sec_id
- number(10)
in database. can't change there. have changed both types in mapping details in vs12
int32
. doesn't help. possible solve problem in vs12? can force accept different values in foreign keys?
i can't map number(10) (ora) decimal(vs) cause additional err:
error 2 error 2019: member mapping specified not valid. type 'edm.decimal[nullable=false,defaultvalue=,precision=,scale=]' of member 'quartal_sec_id' in type 'model.quartal' not compatible 'oracleefprovider.number[nullable=false,defaultvalue=,precision=10,scale=0]' of member 'quartal_sec_id' in type 'model.store.quartal'.
i using ef 5 oracle , number types have our entity properties set decimals.
this article outlines data types.
Comments
Post a Comment