brembot posted on Saturday, August 26, 2006

Sorry for the newbie question. Can anyone knows how to compare the performance of these three Transactional Attributes (TransactionalTypes.Manual, TransactionalTypes.EnterpriseServices, TransactionalTypes.TransactionScope)? What is the ideal or best Transaction Attributes to implement?

Thanks,
Marlon

Bonio replied on Saturday, August 26, 2006

If you are just using an SQL2005 database then I would definitely recommend the TransactionScope - this will save you a lot of hassle and will stop the need to have DTC on your server. You need to pass the SQLConnection object between your update/insert procedures to keep them within the TransactionScope and to prevent an escalation to DTC.

My two penneth anyway :-),

Bonio