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

Popular posts from this blog

c# - How Configure Devart dotConnect for SQLite Code First? -

c++ - Clear the memory after returning a vector in a function -

erlang - Saving a digraph to mnesia is hindered because of its side-effects -