Rollback Inserts/Updates/Deletes in linq pad?

Question

I found this article about how to insert, update and delete using linq pad but it mentions nothing about rolling back anything.

Is it possible to rollback in linqpad?

Answer 1

Yes. You can do:

using (TransactionScope scope = new TransactionScope()) {
  // Put the operations that you want to protect in a transaction here.

  if (you_want_to_commit) {
    scope.Complete();
  }
  // Otherwise, it'll roll back when you exit the using block.
}