Challenge: When debugging the TransactionScope for processing multiple data insert, there is error coming randomly. Solution: It seems that there is timeout issue that needs to be address: The solution turned out to be editing the transaction timeout value in the machine.config file. This is achieved by going to your .Net 2.0 folder and editing [...]