dotnet distributed apps: Hi!

I working on a multilayered enterprise application with Data Access layer
and Transaction Manager Layer.

I am using the SqlHelper.UpdateDataset in MS Data Access Application Block
to update the dataset.

How can I implement transaction management in the Transaction Manager Layer
?
The problem is that following is stated in the documentation:

""" SqlHelper.UpdateDataset does not include transaction support. If you
need this, you can implement it yourself by a preceding call to the helper
method SqlHelper.ExecuteScalar("begin transaction"). """

I would like some examples how to do this in practice?
Any suggestions?

Best regards,
Benjamin

Hi

I didn't mention that we are using MS SQL Server.
That is a prerequisition when using DAAB.


[quoted text, click to view]
database.

LOL!!!! Now that is funny! You might want to know what the heck you're talking about before trying to "help" out.

Damn, I'm still laughing...

---
Posted using Wimdows.net NntpNews Component -

Well that was a totally useless answer ;-) He didn't say he was using MS Access he said he was using "MS Data Access Application Block", two entirely different things. Gotta love knee-jerk replies.

---
Posted using Wimdows.net NntpNews Component -