Hi Vayse,
Because the DeteteBy command will run a TSQL DELETE command in the SQL
directly, I think we need to use another approach.
I think you may try to call FindBy on the Table and call delete method on
the returned datarow.
DataRow.Delete Method
Remarks
If the RowState of the row is Added, the row will be removed from the table.
The RowState becomes Deleted after using the Delete method. It remains
Deleted until you call AcceptChanges.
A deleted row can be undeleted by invoking RejectChanges.
As MSDN said, if you did not call AcceptChanges, the change will not be
applied into database.
Best regards,
Peter Huang
Microsoft Online Partner Support
Get Secure! -
www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.