0 Replies Latest reply: Oct 3, 2012 2:43 PM by 944846 RSS

    Probably Bug - ODP on VS2010

    944846
      Hi,
      i've the below software
      Vs 2010 sp1
      Oracle Client ODP 11.2.0.4

      On the db i've the below table:
      - Parent with field parent_id number (5) as primary_key
      - Child with fields child_id number as primary_key, parent_id as number with a foreign key with Parent.parent_id

      I go on VS in "Server explorer" i made a connection and then i drag the below table on new dataset file.

      After the drag i see the table on the schema but it's lost the foreign key.

      Maybe this depends on the field_type of the foreign key fields.
      Infact for the parent the type is Int32 and for the child is Decimal.

      If i create the table with the same fields size the foreign key i correctly reported on dataset.


      Why this happen? Why doesn't it notice to me?

      Thanks