Devart Forums

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.

Do the DevArt folk read this forum? Should I be submitting a real bug report somewhere else?

We have reproduced the problem for the MS DataSet Wizard. We will investigate the problem and notify you about the results.

At the moment, you may use Devart DataSet Wizard (Tools -> Oracle -> DataSet Wizard in the Visual Studio main menu) as a workaround.

I am unable to use the Devart DataSet Wizard as it doesn't seem to create the TableAdapters. I can see them in the designer but can't find them in the code.

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?

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.

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.