Create a database in SQL Server(SQL Server Express), create a table with the following sql statement:

Workflow:

InsertDataToDBActivity:

Host:

Result:

Check the database, we would find nothing written to database, because there is an exception in TransactionScope Activity. Database will rollback automatically.
81a139ae-0fe0-4271-bfcb-e4ba7349b899|0|.0
WF4