public void InsertAddressWithAddRangeWithoutTransaction()
        {
            var ebayTransactionLabMapper = new EbayTransactionLabMapper();

            ebayTransactionLabMapper.CleanAddressData();

            var address = new List <Address>()
            {
                new Address()
                {
                    Street = "5000 Gandy Street", ZipPostCode = "13057", City = "East Syracuse"
                },
                new Address()
                {
                    Street = "354 Cemetery Street", ZipPostCode = "95004", City = "Aromas"
                },
                new Address()
                {
                    Street = "2031 Reppert Coal Road", ZipPostCode = "45232", City = "Cincinnati"
                }                                                                                               // Street larger than the field in the database
            };

            try
            {
                ebayTransactionLabMapper.InsertAddressWithAddRangeWithoutTransaction(address);
            }
            catch (Exception ex)
            {
                // The records don't be inserted because SaveChanges was used after the error record was added
                throw;
            }
        }
        public void InsertCustomerAndAddressWithAddRangeWithoutTransactionWithDbContextRecycle()
        {
            var ebayTransactionLabMapper = new EbayTransactionLabMapper();

            ebayTransactionLabMapper.CleanCustomerData();
            ebayTransactionLabMapper.CleanAddressData();

            var address = new List <Address>()
            {
                new Address()
                {
                    Street = "5000 Gandy Street", ZipPostCode = "13057", City = "East Syracuse"
                },
                new Address()
                {
                    Street = "354 Cemetery Street", ZipPostCode = "95004", City = "Aromas"
                }
            };

            var customers = new List <Customer>()
            {
                new Customer()
                {
                    Name = "Eleanor A Gutierrez", Birthday = new DateTime(1956, 3, 29), Email = "*****@*****.**", Cpf = "62844343082", AddressId = 4
                },
                new Customer()
                {
                    Name = "Joseph W Barnes", Birthday = new DateTime(1958, 1, 26), Email = "*****@*****.**", Cpf = "7829693200811", AddressId = 1
                },                                                                                                                                                         // Cpf larger than the field in the database
                new Customer()
                {
                    Name = "Leslie M Bump", Birthday = new DateTime(1980, 8, 14), Email = "*****@*****.**", Cpf = "16325104056", AddressId = 2
                }
            };

            try
            {
                ebayTransactionLabMapper.InsertAddressWithAddRangeWithoutTransaction(address);
                ebayTransactionLabMapper.InsertCustomerWithAddRangeWithoutTransaction(customers);
            }
            catch (Exception ex)
            {
                // The Address records will be inserted because SaveChanges was used in a diferent context of Customer records
                throw;
            }
        }