LinqPad 6 EF error on mapping Oracle Tables

Jeann

Hi, I created a new connection to map some Oracle tables, for some reason EF mapped the table primary key (NUMBER (5.0)) to type Int64, but the other tables that have foreign key for the same field were mapped as Int32. This is generating an error message:

  The relationship from 'TSGA_APPLICATION.TSGA_APPLICATION' to 'TSGA_APPLICATION.TSGA_APPLICATION' with foreign key properties {'APPLICATION': int} cannot target the primary key {'APPLATE: long} because it is not compatible. Set the main key or a set of compatible foreign key properties for this relationship.

Follows image of tables and mapping done by EF. Could anyone help me solve?

JoeAlbahari

NUMBER(5,0) should map to Int32, not Int64. Can you set the query language to SQL and run the following query:

SELECT
    OWNER as Owner, TABLE_NAME AS TableName, COLUMN_NAME AS ColumnName, COLUMN_ID AS ID, DATA_TYPE AS DataType, DATA_LENGTH AS Length,
    DATA_PRECISION AS Precision, DATA_SCALE AS Scale, NULLABLE AS Nullable, CHAR_USED, CHAR_LENGTH AS LengthInChars,
    DATA_DEFAULT AS DefaultValue, VIRTUAL_COLUMN AS VirtualColumn
FROM ALL_TAB_COLS WHERE OWNER = 'SGA_ESQUEMA' AND COLUMN_NAME = 'SEQ_APLICATIVO'

and post the output?

Jeann

Hi Joe, thanks for the help. Follow the requested output.

JoeAlbahari

Is it possible for you to post the DDL to create the two tables in question, so that I can reproduce the problem?

Jeann

Yes, I attached the files to this message. Thanks in advance for your help.

JoeAlbahari

I can't recreate the problem with those two tables, but I have an idea of what be the cause. In the query that you ran before, one of the columns (in table TSGA_METODO) has a type number(10,0) instead of number(5,0). Is this a mistake?

Jeann

Yes, it was a mistake. I asked the Database Administrator to fix it and now the mapping is done correctly. Thank you so much for your help.