Transactions

APPLICABLE TO: Grid

Grid allows using transactions for data INSERT/UPDATE/DELETE operations (make sure that the used DB engine has support for transactions).

They can be enabled in 2 modes:

1) global

connector.Request.TransactionMode = TransactionMode.PerRequest;

One request - one big common transaction

  • Component uses single transaction for all records inside single request.
  • If any operation fails, all record operations will be rolled back, all updated rows will be returned with error status
  • If custom validation was assigned and has blocked any record - all records inside of the request will be blocked

2) record

connector.Request.TransactionMode = TransactionMode.PerRecord;

Separate transactions per record

  • Component uses separate transactions for each record in request
  • If any operation fails, it will not affect other operations

To cancel transactions:

connector.Request.TransactionMode = TransactionMode.None;
Back to top