dotConnect Doesn't See Relation

dotConnect Doesn't See Relation

Postby daveoggy » Mon 03 May 2010 14:57

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.
daveoggy
 
Posts: 14
Joined: Fri 23 Jan 2009 18:15

Postby daveoggy » Mon 03 May 2010 21:48

Do the DevArt folk read this forum? Should I be submitting a real bug report somewhere else?
daveoggy
 
Posts: 14
Joined: Fri 23 Jan 2009 18:15

Postby StanislavK » Wed 05 May 2010 16:26

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.
StanislavK
Devart Team
 
Posts: 1710
Joined: Thu 03 Dec 2009 10:48

Postby daveoggy » Fri 07 May 2010 17:54

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.
daveoggy
 
Posts: 14
Joined: Fri 23 Jan 2009 18:15

Postby StanislavK » Tue 11 May 2010 12:11

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?
StanislavK
Devart Team
 
Posts: 1710
Joined: Thu 03 Dec 2009 10:48

Re: dotConnect Doesn't See Relation

Postby Shalex » Tue 27 Aug 2013 14:14

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.
Shalex
Devart Team
 
Posts: 7460
Joined: Thu 14 Aug 2008 12:44

Re: dotConnect Doesn't See Relation

Postby Shalex » Fri 06 Sep 2013 07:43

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.
Shalex
Devart Team
 
Posts: 7460
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for Oracle