LinqPad 6 EF error on mapping Oracle Tables

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?


Sign In or Register to comment.