private static void AddAddressesAndContactsToVendor(AdventureWorksContext ctx) { if (ctx.Vendor.Any()) { var vendorAddresses = SampleData.GetVendorAddresses(); // AUSTRALI0001 var vendor = ctx.Vendor.AsNoTracking() .Where(v => v.AccountNumber == "AUSTRALI0001") .Select(c => new { ID = c.BusinessEntityID }) .SingleOrDefault(); var address = vendorAddresses.First(a => a.AddressLine1 == "28 San Marino Ct" && a.City == "Bellingham"); if (address != null) { address.BusinessEntityAddressObj.BusinessEntityID = vendor.ID; ctx.Address.Add(address); } var contact1 = ctx.Person.AsNoTracking() .Where(c => c.FirstName == "Paula" && c.MiddleName == "B." && c.LastName == "Moberly") .Select(c => new { ID = c.BusinessEntityID }) .SingleOrDefault(); var contact2 = ctx.Person.AsNoTracking() .Where(c => c.FirstName == "Charlene" && c.MiddleName == "J." && c.LastName == "Wojcik") .Select(c => new { ID = c.BusinessEntityID }) .SingleOrDefault(); var contact3 = ctx.Person.AsNoTracking() .Where(c => c.FirstName == "Jo" && c.MiddleName == "J." && c.LastName == "Zimmerman") .Select(c => new { ID = c.BusinessEntityID }) .SingleOrDefault(); var bc1 = new BusinessEntityContact { BusinessEntityID = vendor.ID, PersonID = contact1.ID, ContactTypeID = 18 }; var bc2 = new BusinessEntityContact { BusinessEntityID = vendor.ID, PersonID = contact2.ID, ContactTypeID = 19 }; var bc3 = new BusinessEntityContact { BusinessEntityID = vendor.ID, PersonID = contact3.ID, ContactTypeID = 17 }; ctx.BusinessEntityContact.AddRange(new List <BusinessEntityContact> { bc1, bc2, bc3 }); // TRIKES0001 vendor = ctx.Vendor.AsNoTracking() .Where(v => v.AccountNumber == "TRIKES0001") .Select(c => new { ID = c.BusinessEntityID }) .SingleOrDefault(); address = vendorAddresses.First(a => a.AddressLine1 == "90 Sunny Ave" && a.City == "Berkeley"); if (address != null) { address.BusinessEntityAddressObj.BusinessEntityID = vendor.ID; ctx.Address.Add(address); } var contact4 = ctx.Person.AsNoTracking() .Where(c => c.FirstName == "William" && c.MiddleName == "J." && c.LastName == "Monroe") .Select(c => new { ID = c.BusinessEntityID }) .SingleOrDefault(); var bc4 = new BusinessEntityContact { BusinessEntityID = vendor.ID, PersonID = contact4.ID, ContactTypeID = 18 }; ctx.BusinessEntityContact.Add(bc4); // LIGHTSP0001 vendor = ctx.Vendor.AsNoTracking() .Where(v => v.AccountNumber == "LIGHTSP0001") .Select(c => new { ID = c.BusinessEntityID }) .SingleOrDefault(); address = vendorAddresses.First(a => a.AddressLine1 == "298 Sunnybrook Drive" && a.City == "Spring Valley"); if (address != null) { address.BusinessEntityAddressObj.BusinessEntityID = vendor.ID; ctx.Address.Add(address); } var contact5 = ctx.Person.AsNoTracking() .Where(c => c.FirstName == "Marie" && c.MiddleName == "E." && c.LastName == "Moya") .Select(c => new { ID = c.BusinessEntityID }) .SingleOrDefault(); var bc5 = new BusinessEntityContact { BusinessEntityID = vendor.ID, PersonID = contact5.ID, ContactTypeID = 17 }; ctx.BusinessEntityContact.Add(bc5); // DFWBIRE0001 var dfwVendor = ctx.Vendor.AsNoTracking() .Where(v => v.AccountNumber == "DFWBIRE0001") .Select(c => new { ID = c.BusinessEntityID }) .SingleOrDefault(); var terriPhide = ctx.Person.AsNoTracking() .Where(c => c.FirstName == "Terri" && c.LastName == "Phide") .Select(c => new { ID = c.BusinessEntityID }) .SingleOrDefault(); var bc6 = new BusinessEntityContact { BusinessEntityID = dfwVendor.ID, PersonID = terriPhide.ID, ContactTypeID = 17 }; ctx.BusinessEntityContact.Add(bc6); // DESOTOB0001 var desotoVendor = ctx.Vendor.AsNoTracking() .Where(v => v.AccountNumber == "DESOTOB0001") .Select(c => new { ID = c.BusinessEntityID }) .SingleOrDefault(); var address1 = vendorAddresses.First(a => a.AddressLine1 == "1900 Desoto Court" && a.City == "Desoto"); if (address1 != null) { address1.BusinessEntityAddressObj.BusinessEntityID = desotoVendor.ID; address1.BusinessEntityAddressObj.AddressTypeID = 3; ctx.Address.Add(address1); } var address2 = vendorAddresses.FirstOrDefault(a => a.AddressLine1 == "211 East Pleasant Run Rd" && a.City == "Desoto"); if (address2 != null) { address2.BusinessEntityAddressObj.BusinessEntityID = desotoVendor.ID; address2.BusinessEntityAddressObj.AddressTypeID = 7; ctx.Address.Add(address2); } var johnnyDough = ctx.Person.AsNoTracking() .Where(c => c.FirstName == "Johnny" && c.LastName == "Dough") .Select(c => new { ID = c.BusinessEntityID }) .SingleOrDefault(); var bc7 = new BusinessEntityContact { BusinessEntityID = desotoVendor.ID, PersonID = johnnyDough.ID, ContactTypeID = 17 }; ctx.BusinessEntityContact.Add(bc7); // CYCLERU0001 var rusVendor = ctx.Vendor.AsNoTracking() .Where(v => v.AccountNumber == "CYCLERU0001") .Select(c => new { ID = c.BusinessEntityID }) .SingleOrDefault(); address = vendorAddresses.FirstOrDefault(a => a.AddressLine1 == "6266 Melody Lane" && a.City == "Dallas"); if (address != null) { address.BusinessEntityAddressObj.BusinessEntityID = rusVendor.ID; address.BusinessEntityAddressObj.AddressTypeID = 3; ctx.Address.Add(address); } ctx.SaveChanges(); } }
private static void AddAddressesToEmployees(AdventureWorksContext ctx) { if (ctx.Person.Any()) { var peopleAddresses = SampleData.GetPeopleAddresses(); var query = ctx.Person.AsNoTracking() .Where(p => p.FirstName == "Ken" && p.MiddleName == "J" && p.LastName == "Sanchez") .Select(obj => new { obj.BusinessEntityID }) .SingleOrDefault(); var address = peopleAddresses.FirstOrDefault(a => a.AddressLine1 == "4350 Minute Dr." && a.City == "Newport Hills"); if (address != null) { address.BusinessEntityAddressObj.BusinessEntityID = query.BusinessEntityID; ctx.Address.Add(address); } query = ctx.Person.AsNoTracking() .Where(p => p.FirstName == "Terri" && p.MiddleName == "Lee" && p.LastName == "Duffy") .Select(v => new { v.BusinessEntityID }) .SingleOrDefault(); address = peopleAddresses.FirstOrDefault(a => a.AddressLine1 == "7559 Worth Ct." && a.City == "Renton"); if (address != null) { address.BusinessEntityAddressObj.BusinessEntityID = query.BusinessEntityID; ctx.Address.Add(address); } query = ctx.Person.AsNoTracking() .Where(p => p.FirstName == "Gail" && p.MiddleName == "A" && p.LastName == "Erickson") .Select(v => new { v.BusinessEntityID }) .SingleOrDefault(); address = peopleAddresses.FirstOrDefault(a => a.AddressLine1 == "9435 Breck Court" && a.City == "Bellevue"); if (address != null) { address.BusinessEntityAddressObj.BusinessEntityID = query.BusinessEntityID; ctx.Address.Add(address); } query = ctx.Person.AsNoTracking() .Where(p => p.FirstName == "Jossef" && p.MiddleName == "H" && p.LastName == "Goldberg") .Select(v => new { v.BusinessEntityID }) .SingleOrDefault(); address = peopleAddresses.FirstOrDefault(a => a.AddressLine1 == "5670 Bel Air Dr." && a.City == "Renton"); if (address != null) { address.BusinessEntityAddressObj.BusinessEntityID = query.BusinessEntityID; ctx.Address.Add(address); } query = ctx.Person.AsNoTracking() .Where(p => p.FirstName == "Diane" && p.MiddleName == "L" && p.LastName == "Margheim") .Select(v => new { v.BusinessEntityID }) .SingleOrDefault(); address = peopleAddresses.FirstOrDefault(a => a.AddressLine1 == "475 Santa Maria" && a.City == "Everett"); if (address != null) { address.BusinessEntityAddressObj.BusinessEntityID = query.BusinessEntityID; ctx.Address.Add(address); } ctx.SaveChanges(); } }