which is the best method in transactional system? using TransactionScope in Business Layer or inside Database?
I am using SQL Server 2008 and C3 with Framework 4.0
Inside Business Layer like:
using (TransactionScope scope = new TransactionScope())
{
...
scope.Complete();
}
Or inside Database like:
Begin tran InsertTrace
Begin try
...
End try
Begin Catch
Rollback tran InsertTrace
...
End Catch