private async Task <MarketingContactEntity> InsertContact(string solutionId)
        {
            var expected1 = MarketingContactEntityBuilder.Create()
                            .WithSolutionId(solutionId)
                            .WithFirstName(Guid.NewGuid().ToString().Substring(0, 25))
                            .WithLastName(Guid.NewGuid().ToString().Substring(0, 25))
                            .WithDepartment(Guid.NewGuid().ToString().Substring(0, 25))
                            .WithEmail(Guid.NewGuid().ToString().Substring(0, 25))
                            .WithPhoneNumber(Guid.NewGuid().ToString().Substring(0, 25))
                            .Build();

            await expected1.InsertAsync().ConfigureAwait(false);

            return(expected1);
        }
        public async Task ShouldReturnCorrectId()
        {
            await MarketingContactEntityBuilder.Create()
            .WithSolutionId(_solutionId1)
            .WithFirstName("FirstName1")
            .Build()
            .InsertAsync();

            await MarketingContactEntityBuilder.Create()
            .WithSolutionId(_solutionId1)
            .WithFirstName("FirstName2")
            .Build()
            .InsertAsync();

            var result = (await _marketingContactRepository.BySolutionIdAsync(_solutionId1, new CancellationToken())).ToList();

            var id = (await _testContext.DbConnector.QueryAsync <int>("SELECT Id FROM dbo.MarketingContact WHERE FirstName = 'FirstName2';", new CancellationToken())).Single();

            result.Single(m => m.FirstName == "FirstName2").Id.Should().Be(id);
        }