Database Transactions and concurrent requests

Questions
1

Hi,

  1. When I call order.Save() is there a implicit sql transaction which wraps all the sql delete/insert/update statements that I assume are executed under the hood? Or is it my responsibility to do transaction management?

  2. Related, what happens if two requests try to save the same order at the same time (or even a save and read concurrent requests)? Is that handled by TeaCommerece/Umbraco/PetaPOCO, or is it my responsibility? I’m trying to understand the reason for a an duplicate key sql exception being thrown in my code on a webhook call from the payment provider (Stripe).

Thanks,
-Tor

This is a companion discussion topic for the original entry at https://our.umbraco.com/forum/98026-database-transactions-and-concurrent-requests