VB.Net, use linq transaction to run s/p that contains transaction

I have some VB.Net code that runs several SQL stored procedures in sequence.  Table updates within each of the sprocs are wrapped in a transaction.  For example, sp1 starts a transaction, updates 5 tables, commits or rollsback.  It returns a success code to the calling program.  If successful, sp2 starts a transaction, updates 3 tables, commits or rollsback.  It returns a success code to the calling program.  If successful ... and so on.

I am using linq so I have:

dc.sp1(parameters,success)
If success = true then
    dc.sp2(parameters, success)
    if success = true then
        dc.sp3(parameters,success)
    end if
end if

and so on

What I want to do is start a transaction for dc and if success is false for ANY of the sprocs, roll everything back.

In other words, there will be transactions within the "dc transaction".  If the dc transaction is rolled back, will the nested transactions also be rolled back?
LVL 4
g_johnsonAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

CodeCruiserCommented:
Committing inner transactions is ignored by the SQL Server Database Engine. The transaction is either committed or rolled back based on the action taken at the end of the outermost transaction.

http://msdn.microsoft.com/en-us/library/ms189336.aspx
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic.NET

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.