transaction is not rolling back from TransactionScope

Question

It has started confusing me.

I am using transaction Scope and the transaction is not rolling bake the insert to the database in the Fill_WO_Report_Table(..).

I am looking for specific solution to this problem because i have already researched about this topic on forums.

my code:

 public bool Generate(decimal wo_id)
 {
        string exception;
        using (var scope = new TransactionScope())
        {                
            try
            {
                if (Fill_WO_Report_Table(wo_id, out exception) == false)
                {                        
                        scope.Dispose();
                        throw new Exception("Cannot Complete Transaction.\n" + exception);
                }

. . // other code logic // other code logic . .

                if (Drop_WO_Report_Table(out exception) == false)
                    throw new Exception("Cannot Complete Transaction" + exception);


                scope.Complete();
                scope.Dispose();

                return true;
            }
            catch (Exception exe)
            {
                scope.Dispose();
                MessageBox.Show(exe.Message, "WO Report", MessageBoxButtons.OK, MessageBoxIcon.Error);
                return false;
            }
        }// scope

Fill_WO_Report_Table() function is as under : -

    public bool Fill_WO_Report_Table(decimal wo_id, out string excp)
    {

        try
        {                
            if (GetCompanyDetails(ref dtCompany_Details, out excp) == false)
                throw new Exception(excp);
            if (excp != null)
            {
                MessageBox.Show("Failed to Load Company Details.\n" + excp, "WO Report", MessageBoxButtons.OK, MessageBoxIcon.Error);
                return false;
            }


            //query1
            functionToExecQuery();
            //query2
            functionToExecQuery();
            //query3
            functionToExecQuery();
            //query4
            functionToExecQuery();

            return true;
        }
        catch (Exception exe)
        {            
            return false;
            throw;
        }

When the exception is raised from functionToExecQuery() for Query3 it should roll back the Create or insert performed in Query1 and Query2.

How can i achieve this ?

and i have also tried removing the dispose() after Complete(), but it did not rollback, i am using .Net3.5, — Ankityp, Aug 07 '15 at 10:44
remove the disposes, using will auto dispose the object when it is complete. — Diogo Cunha, Aug 07 '15 at 10:45
I am not 100 percent sure right now if it's a hard requirement, but normally you would create the scope before creating the connection to have the connection enrolled in the transaction scope. — 500 - Internal Server Error, Aug 07 '15 at 10:45
Looks like a duplicate http://stackoverflow.com/questions/339269/transactionscope-not-rolling-back-transaction?rq=1 — , Aug 07 '15 at 10:55
@neil, i have tried this solution before but it never worked. — Ankityp, Aug 07 '15 at 11:01

transaction is not rolling back from TransactionScope

0 Answers0