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


Return to LinqConnect (LINQ to SQL support)