>>Say, I do want a transaction and I do want everything to happen, but at the end, I don't want to commit it. Do I simply omit scope.Complete() and expect it will be rollbacked at the end of the using statement?
>
>Yes, if there is no scope.Complete(), then it all gets rolled back!
>
>~~Bonnie

It doesn't seem to work this way :(

This is my code:

 String result = "";
         middlewareMain.Rollback = false;
         using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, new TransactionOptions() { IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted }))
         {
            result = middlewareMain.Invoke(input);
         }
         middlewareMain.Rollback = true;

The method inserts new rows into database and I do actually have these rows now. Do you know what may be the problem?

Thanks in advance.