public async void MigratedProducerExists_ForMatchingProducerRegistrationNumber_Returns_True()
        {
            using (var database = new DatabaseWrapper())
            {
                var migratedProducer = new MigratedProducer_();
                migratedProducer.CompanyNumber = "AAA";
                migratedProducer.ProducerName  = "Test producer";
                migratedProducer.ProducerRegistrationNumber = "1234";

                database.Model.MigratedProducer_Set.Add(migratedProducer);
                database.Model.SaveChanges();

                var dataAccess = new GenerateFromXmlDataAccess(database.WeeeContext);
                var result     = await dataAccess.MigratedProducerExists("1234");

                Assert.True(result);
            }
        }
        public void GetMigratedProducer_PrnExists_ReturnsMigratedProducer()
        {
            using (DatabaseWrapper database = new DatabaseWrapper())
            {
                // Arrange
                MigratedProducer_ migratedProducer1 = new MigratedProducer_();
                migratedProducer1.Id = new Guid("B1750CCE-77D9-4A11-9ACC-D29D692FAA52");
                migratedProducer1.ProducerRegistrationNumber = "ABC";
                migratedProducer1.ProducerName = "Test Producer 1";

                database.Model.MigratedProducer_Set.Add(migratedProducer1);
                database.Model.SaveChanges();

                MigratedProducerQuerySet querySet = new MigratedProducerQuerySet(database.WeeeContext);

                // Act
                EA.Weee.Domain.Producer.MigratedProducer result = querySet.GetMigratedProducer("ABC");

                // Assert
                Assert.NotNull(result);
                Assert.Equal(new Guid("B1750CCE-77D9-4A11-9ACC-D29D692FAA52"), result.Id);
                Assert.Equal("Test Producer 1", result.ProducerName);
            }
        }