Insert child entity with foreign key relationship fails

Insert child entity with foreign key relationship fails

Postby kboeckm » Tue 04 Oct 2011 16:51

I have Entity A that contains child entity B which contains child entity C. Entity A has a unique primary key that is generated via sequence generator. Entity B and C have a foreign key relationship to entity A in the database. This is done to make querying data easier. On inserts, Entity A is inserted fine along with Entity B. The unique key for Entity A is generated and added to Entity B. However, this does not work for Entity C. The insert does not take the unique key generated for Entity A and apply it to the foreign key relationship for Entity C. How can I make this work?

Visual Studio 2010.
dotConnect for Oracle v6.5.228
LinqConnect Professional 3.0.5
Posts: 10
Joined: Tue 14 Jun 2011 20:47

Postby StanislavK » Fri 07 Oct 2011 12:06

We couldn't reproduce the problem in our environment. I will send you a test project, please check that the letter was not blocked by your mail filter. Please specify what should be changed in the sample to reproduce the issue.
Devart Team
Posts: 1710
Joined: Thu 03 Dec 2009 10:48

Return to LinqConnect (LINQ to SQL support)