When using TransactionScope, I'm checking for success this way:
Dim Success as Boolean = False
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.