delete row in disconnected dataSet
Once you deleted a DataRow, none of its fields are accessible;
thiugh you can count how many rows were deleted, by filtering on the
DataView's RowStateFilter,
you can't access the fields themselves.
Now this is very restrictive in a disconnected environment :
suppose you have 2 tables, T1 and T2, where field F2 of T2 references field
F1 of T1;
and suppose you cannot set a foreign key relationship, for some good reason;
suppose you fetch a dataSet DS1 containing T1 from the server,
and then continue working on the dataSet in a disconnected way, for some
days;
and suppose you delete a row R1;
suppose you syncronize after a few days with the server, by doing an Update
on the dataSet DS1;
what you now want to happen, is that the server deletes all rows R2 from T2
if they reference R1;
but, though the server can update (=delete) row R1, it can not use R1 to
find all associated R2's,
because the fields of R1 are not accessible anymore;
how can you ever delete R1 without having immediate (not disconnected)
access to the server ?
or without recurring to an artificial mechanism defeating the
self-containing purpose of a dataSet ?