public async void RemoveClaimDocument() { _logger.LogInformation("AddClaimDocument..."); var claimId = _claimsFixture.Items.First().ClaimId; Document insertedDocument; using (var dbTransaction = await _dbConnectionFactory.BeginUserTransactionAsync(_userId)) { var newItem = new Document() { Name = $"REPOSITORY_TEST_{DateTime.Now:yyyyMMddHHmmssfff}.jpg", Type = "jpg", Data = await File.ReadAllBytesAsync("./TestFiles/Test.jpg") }; insertedDocument = await _repository.InsertDocumentAsync(dbTransaction, newItem); await _repository.AddClaimDocument(dbTransaction, claimId, insertedDocument.DocumentId); dbTransaction.Commit(); } using (var dbConnection = await _dbConnectionFactory.OpenUserConnectionAsync(_userId)) { var result = await _repository.GetClaimDocumentsAsync(dbConnection, claimId); Assert.NotNull(result); Assert.Contains(result, candidate => candidate.DocumentId == insertedDocument.DocumentId); } using (var dbTransaction = await _dbConnectionFactory.BeginUserTransactionAsync(_userId)) { await _repository.RemoveClaimDocument(dbTransaction, claimId, insertedDocument.DocumentId); dbTransaction.Commit(); } using (var dbConnection = await _dbConnectionFactory.OpenUserConnectionAsync(_userId)) { var result = await _repository.GetClaimDocumentsAsync(dbConnection, claimId); Assert.NotNull(result); Assert.DoesNotContain(result, candidate => candidate.DocumentId == insertedDocument.DocumentId); } }