Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
Database Developer Tools
Windows and .NET
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Oct 3, 2012 2:43 PM by
Probably Bug - ODP on VS2010
Oct 3, 2012 2:43 PM
i've the below software
Vs 2010 sp1
Oracle Client ODP 220.127.116.11
On the db i've the below table:
with field parent_id number (5) as primary_key
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?
This content has been marked as final.
Show 0 replies