We help IT Professionals succeed at work.
Get Started

TransactionScope With Conditional Deletes, Selects

DaveKid asked
Last Modified: 2014-05-22
When using TransactionScope, I'm checking for success this way:

Dim Success as Boolean = False

...code, code,code
success = oCom.ExecuteNonQuery()

I saw it in many examples provided by Microsoft.   However, I'm having an issue with a conditional delete.   I have a delete statement that doesn't always find rows to delete.  So sometimes it returns 0 and therefore success would be set to False.

Additional, the method above cannot be used with a select statement at all.  Do I even really need it for a select?  

If someone could give me an elegant way to handle my delete I would appreciate it.  And if you could tell me whether I really even need to check the select that would be appreciated as well.
Watch Question
Senior Systems and Integration Developer
This problem has been solved!
Unlock 2 Answers and 5 Comments.
See Answers
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE