In this task, we will create a workflow with
activity, in which a customized activity will insert some data in the database. If any exception/error occurs, the newly inserted data will be rolled back.
Create a new Workflow Console Application and name it
Create a new database in SQL Server (or SQL Server Express) and name it
TransactionDB. Use the following SQL statement to create a new table:
create table UserTable( UserID nvarchar(50) primary key )
Add a reference to the
System.Tranactions namespace because we are going to use