dotConnect Doesn't See Relation

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
daveoggy
Posts: 14
Joined: Fri 23 Jan 2009 18:15

dotConnect Doesn't See Relation

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

Post by daveoggy » Mon 03 May 2010 21:48

Do the DevArt folk read this forum? Should I be submitting a real bug report somewhere else?
Top
StanislavK
Devart Team
Posts: 1710
Joined: Thu 03 Dec 2009 10:48

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

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

Post by 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?
Top
Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: dotConnect Doesn't See Relation

Post by 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.
Top
Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: dotConnect Doesn't See Relation

Post by 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.
Top
Post Reply

Return to “dotConnect for Oracle”