When the resulting SQL statements for a SaveChanges call completed successfully, the record-status and modification-tracking for records will be altered:

  • New records become Existing and all columns are reset to not-modified;
  • The columns for Existing records are reset to not-modified;
  • ExistingDelete records are deleted from the resultset.

Should an error happen during execution of the SQL statements, for example a deadlock error, then the database will rollback the transaction, and an Exception will be thrown.

An exception thrown on the middle-tier will be re-thrown on the client as a Ventura.RemoteException