Can anyone please tell me what is the prefered way to manage transaction when using Enterprise Library's DAAB (version 4.1)? I was thinking about
Database NewDb = DatabaseFactory.CreateDatabase();
DBCommand NewCmd = NewDb.GetStoredProcCommand("SProcName");
/* Add parameters here. */
using (TransactionScope NewTrans = new TransactionScope())
{
NewDb.ExecuteNonQuery(NewCmd);
NewTrans.Complete()
}
but I don't know if I will be doing the right way.