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 
this?

Thanks,

Kevin