C
Chris Hock
I'm using VS.Net 2003 (C#). I have a data adapter which
performs simple CRUD operations on a table. When creating
the data adapter I opted NOT to use the Optimistic
concurrency.
The sql update statement works as expected. The row
updates regardless of whether the data was modified after
the read and prior to the update. However, the delete
appears to always require a row be deleted. My
application reads the row, then I delete the row from the
SQL Server table manually, and then I try to delete the
row with the application.
If I turn off Optimistic concurrency I would expect the
delete statement to not care whether the row existed or
not. However, it appears that it requires at least one
row to be deleted regardless of whether Optimistic
concurrency is used or not.
Does anyone know a way around this issue? I want the
delete operation to succeed regardless of how many rows
are deleted.
Thanks,
Chris
performs simple CRUD operations on a table. When creating
the data adapter I opted NOT to use the Optimistic
concurrency.
The sql update statement works as expected. The row
updates regardless of whether the data was modified after
the read and prior to the update. However, the delete
appears to always require a row be deleted. My
application reads the row, then I delete the row from the
SQL Server table manually, and then I try to delete the
row with the application.
If I turn off Optimistic concurrency I would expect the
delete statement to not care whether the row existed or
not. However, it appears that it requires at least one
row to be deleted regardless of whether Optimistic
concurrency is used or not.
Does anyone know a way around this issue? I want the
delete operation to succeed regardless of how many rows
are deleted.
Thanks,
Chris