Workaround for the issue using SqlTransaction instead of ambient transaction