Devart Forums

Hi,
using LinqToOracle in a master detail scenario, if i add detail row and then i remove the same row, when i call SubmitChanges the provider try to insert null row that raise an exception.

What can i do?

Could you please provide a code sample illustrating actions leading to this error?

DataContext1.Table1 tab1 = FDb.Table1s.First();

tab1.Table2s.Add(new DataContext1.Table2());
tab1.Table2s.Add(new DataContext1.Table2());
tab1.Table2s.Add(new DataContext1.Table2());
tab1.Table2s.Add(new DataContext1.Table2());
tab1.Table2s.Add(new DataContext1.Table2());
tab1.Table2s.Add(new DataContext1.Table2());
tab1.Table2s.Add(new DataContext1.Table2());
tab1.Table2s.Add(new DataContext1.Table2());

while (tab1.Table2s.Count() > 0)
tab1.Table2s.RemoveAt(0);

FDb.Log = Console.Out;

FDb.SubmitChanges();

An the output windows diplay this:

INSERT INTO MAGAZZINO.TABLE2 (ID_TABLE1, CODICE, DESCRIZIONE) VALUES (:p1, :p2, :p3) RETURNING ID INTO :ret1
ParameterName = p1
DbType = Decimal
Value =
ParameterName = p2
DbType = String
Value =
ParameterName = p3
DbType = String
Value =
ParameterName = ret1
DbType = Decimal
Value =

Solved,
5.35 beta don't do this.

We have reproduced the issue with removing entities from EntitySet without explicit call of InsertOnSubmit (the removed records are inserted into database with the 5.35.52 version of dotConnect for Oracle). The problem is fixed. Look forward to the next build of dotConnect for Oracle.