I have a table defined with a self referencing relationship. The table has an ID column and a PARENT_ID column. ID is the primary key, PARENT_ID is the foreign key and is set to reference the primary key in this same table
Both the ".net Framework Data Provider for Oracle" (System.Data.OracleClient) and "ODP.Net (Oracle.DataAccess)" systems are able to create the table in my dataset with the relation correctly implemented. When using dotConnect the table is created with no relations whatsoever.
dotConnect Doesn't See Relation
-
- Devart Team
- Posts: 1710
- Joined: Thu 03 Dec 2009 10:48
-
- Devart Team
- Posts: 1710
- Joined: Thu 03 Dec 2009 10:48
Devart DataSet Wizard creates extensions of the OracleDataTable class instead of TableAdapters. For more information on OracleDataTable, please see the corresponding topic of our documentation:
http://www.devart.com/dotconnect/oracle ... Table.html
Could you please describe the scenario in which you are using typed DataSets in more details so that we are able to suggest a workaround using OracleDataTables?
http://www.devart.com/dotconnect/oracle ... Table.html
Could you please describe the scenario in which you are using typed DataSets in more details so that we are able to suggest a workaround using OracleDataTables?
Re: dotConnect Doesn't See Relation
The bug with detecting self-relations in Microsoft DataSet Wizard is fixed. We will post here when the corresponding build of dotConnect for Oracle is available for download.
Re: dotConnect Doesn't See Relation
New version of dotConnect for Oracle 7.9 is released!
It can be downloaded from http://www.devart.com/dotconnect/oracle/download.html (trial version) or from Registered Users' Area (for users with active subscription only).
For more information, please refer to http://forums.devart.com/viewtopic.php?f=1&t=27875.
It can be downloaded from http://www.devart.com/dotconnect/oracle/download.html (trial version) or from Registered Users' Area (for users with active subscription only).
For more information, please refer to http://forums.devart.com/viewtopic.php?f=1&t=27875.