Hi Chris,

I still can't reproduce the problem.  I followed your specifications and
wrote the following code, which results in no errors, 3 records persisted in
the parent database table and all related child records having a RowState of
Added:

// Note: I tried with an auto-increment PK and with a string PK
// and both produced the same results

DataSet data = new DataSet();

DataTable parent = data.Tables.Add("ParentTable");
DataColumn pk = parent.Columns.Add("ParentID", typeof(int));
pk.AutoIncrement = true;
pk.AllowDBNull = false;
pk.ReadOnly = true;
parent.Constraints.Add("PK_ParentID", pk, true);
parent.Columns.Add("Text", typeof(string));

DataTable child = data.Tables.Add("ChildTable");
child.Columns.Add("ChildID", typeof(string));
child.Columns.Add("ParentID", typeof(int));

ForeignKeyConstraint foreignKeyConstraint =
   (ForeignKeyConstraint) child.Constraints.Add("FK_Child_Parent",
       parent.Columns[0], child.Columns[1]);

foreignKeyConstraint.UpdateRule = Rule.Cascade;

child.Rows.Add("C1",
   parent.Rows.Add(null, "P1")["ParentID"]);
child.Rows.Add("C2",
   parent.Rows.Add(null, "P2")["ParentID"]);
child.Rows.Add("C3",
   parent.Rows.Add(null, "P3")["ParentID"]);

foreach (DataRow row in parent.Rows)
   Debug.Assert(row.RowState == DataRowState.Added);

foreach (DataRow row in child.Rows)
   Debug.Assert(row.RowState == DataRowState.Added);

using (SqlConnection connection = new SqlConnection(
   Properties.Settings.Default.TestingConnectionString))
{
   using (SqlDataAdapter adapter = new SqlDataAdapter())
   {
       using (SqlCommand command = new SqlCommand(
           @"INSERT ParentTable SELECT @Text;
               SELECT SCOPE_IDENTITY();", connection))
       {
           command.Parameters.Add("@Text", SqlDbType.NVarChar, 50, "Text");

           adapter.AcceptChangesDuringUpdate = false;
           adapter.InsertCommand = command;
           adapter.Update(parent); // parent is a DataTable
       }
   }
}

foreach (DataRow row in parent.Rows)
   // check for Modified since pk is updated by adapter
   Debug.Assert(row.RowState == DataRowState.Modified,
       row["Text"].ToString() + ": Invalid parent RowState: " +
       row.RowState.ToString());

foreach (DataRow row in child.Rows)
   Debug.Assert(row.RowState == DataRowState.Added,
       row["ChildID"].ToString() + ": Invalid child RowState: " +
       row.RowState.ToString());

MessageBox.Show("Done!");

Hi,

The DataAdapter will obviously use your InsertCommand foreach Added row, but
it does it like this:

-> RowState.Added
1) setup command/set parameter values ...etc...
2) execute InsertCommand
3) if the InsertCommand.UpdatedRowSource = FirstReturnedRecord
(which is quite normal if you use autonumber keys), then it will _always_
call AcceptChanges
-> RowState.Unmodified
4) load the values from FirstReturnedRecord into the DataRow
(this will set the new pk)
-> RowState.Modified
5) if AcceptChangesDuringUpdate = true, call AcceptChanges again
-> RowState.Unmodified

So, if you use an InsertCommand which retrieves the autonumber key, then
turning off AcceptChangesDuringUpdate will make the RowState go from Added
to Modified.

And if the ForeignKeyConstraint has AcceptRejectRule=Cascade then a similar
thing will happen for the related child rows:  when AcceptChanges is called
on the parent row (3) it will cascade and call AcceptChanges on the child
row, changing its state to unmodifed, then when the new key is retrieved (4)
it will propagate the key to the child row (UpdateRule=Cascade), making the
child row enter a modified state.

Offcourse i don't know whether you are using AcceptRejectRule=Cascade but if
you are you should probely not, there are very few situations where this is
wanted.

HTH,
Greetings