Devart Forums

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

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

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.

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