Deadlock issue with concurrency

Uncategorized

Fixing issue by wrapping all DAL calls in explicit transactions to avoid using implicit transaction with non-predictable isolation level.