SubmitChanges() - Child Entities Not Deleted

kboeckm · Post by **kboeckm** » Wed 03 Aug 2011 15:59

I have Entity A which contains a EntitySet. If I make no modifications to Entity A and delete/add several items from EntitySet LinqConnect generates the correct insert/delete statements.

However, if i make a change to Entity A AND delete/add several items from EntitySet LinqConnect generates an Update statement for Entity A but only generates the Insert statements for EntitySet not the delete statements.

If I look at the GetChangeSet() results prior to calling SubmitChanges(), it has the correct results. However, LinqConnect does not generate the correct SQL statements.

I should also note I'm working in a disconnected state. The ORM objects are handed over to an MVC layer where they are changed via jquery. When finished editing, the data is sent back to the server via JSON and mapped to ORM objects and attached to the datacontext.

Is this a known issue? Any thoughts on what I could be doing wrong?

Visual Studio: 2010
LinqConnect: 2.50.25.0
dotConnect for Oracle: 6.30.172.0

StanislavK · Post by **StanislavK** » Thu 04 Aug 2011 15:52

Thank you for the report, we've reproduced the issue. We will inform you as soon as it is fixed.

kboeckm · Post by **kboeckm** » Thu 04 Aug 2011 16:03

That's the third defect I've discovered in the last month or two using your product. At this point, I definately would not recommend your product to the development community.

StanislavK · Post by **StanislavK** » Fri 07 Oct 2011 09:50

The fix for this issue is available in the latest 3.0.5 build of LinqConnect. The new build can be downloaded from
http://www.devart.com/linqconnect/download.html
(the trial only) or from Registered Users' Area (for users with active subscription only).

For more information about the fixes and improvements available in LinqConnect 3.0.5, please refer to
http://www.devart.com/forums/viewtopic.php?t=22168