How to manage SqlTransactions while keeping database layer simple.

[waheed azad]

Hi,

My DataAccess layers are usually composed of One class per Database table with common functions like insert update etc. So far i'm maintaining the transactions from my business layer, I wanted to know that what stretegies one could use to keep DataAccess simple and also use transactions in it.

Thanks in advance..

waheed.