Insert child entity with foreign key relationship fails

kboeckm · Post by **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

StanislavK · Post by **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.