aspdotnet_website_programming thread: Implementing ADO.NET Connection-Based Transactions
I am building an application using the data access approach outlined in
the book by having a BaseDAL class that acts as the base data access class
from which my specific data access classes inherit.
However, I would like to modify this approach so that it allows my
business objects to begin, and then commit or rollback transactions. In
the examples in this book, the transactions are handled in the stored
procedures. Because of certain design issues, I would rather handle some
of these using ADO.NET connection-based transactions.
Any thoughts on how to adapt the approach outlined in the book to support