private static void SeedDb() { using var context = new AnimalContext(); context.SavedChanges += (sender, args) => { Console.ForegroundColor = ConsoleColor.Red; Console.WriteLine( $"Saved {args.EntitiesSavedCount} changes for {((DbContext) sender)?.Database.GetConnectionString()}"); Console.ForegroundColor = ConsoleColor.White; }; context.Database.EnsureDeleted(); context.Database.EnsureCreated(); #region Seed TPT (Animal) var beaver1 = new Beaver { Name = "SomeBeavers1", Age = 27, Fluffiness = FluffinessEnum.VeryFluffy, Size = 15, IpAddress = IPAddress.Parse("127.0.0.1") }; var beaver2 = new Beaver { Name = "SomeBeavers2", Age = 26, Fluffiness = FluffinessEnum.Fluffy, Size = 14, IpAddress = IPAddress.Parse("127.0.0.1") }; var beaver3 = new Beaver { Name = "SomeBeavers3", Age = 25, Fluffiness = FluffinessEnum.NotFluffy, Size = 13, IpAddress = IPAddress.Parse("127.0.0.1") }; var beaver4 = new Beaver { Name = "SomeBeavers4", Age = 24, Fluffiness = FluffinessEnum.Fluffy, Size = 12, IpAddress = IPAddress.Parse("127.0.0.1") }; var beaver5 = new Beaver { Name = "SomeBeavers5", Age = 23, Fluffiness = FluffinessEnum.VeryFluffy, Size = 11, IpAddress = IPAddress.Parse("127.0.0.1") }; var crow1 = new Crow { Name = "Crowly", Age = 5, Color = "black", Size = 1, IpAddress = IPAddress.Parse("127.0.0.1") }; var crow2 = new Crow { Name = "Crowly1", Age = 5, Color = "black", Size = 1, IpAddress = IPAddress.Parse("127.0.0.1") }; var crow3 = new Crow { Name = "Crowly2", Age = 22, Color = "black", Size = 4, IpAddress = IPAddress.Parse("127.0.0.1") }; var crow4 = new Crow { Name = "Crowly3", Age = 50, Color = "white", Size = 10, IpAddress = IPAddress.Parse("127.0.0.1") }; var crow5 = new Crow { Name = "Crowly4", Age = 5, Color = "pink", Size = 1, IpAddress = IPAddress.Parse("127.0.0.1") }; var deer1 = new Deer { Name = "Dasher", Age = 1, Horns = true, IpAddress = IPAddress.Parse("127.0.0.1") }; var deer2 = new Deer { Name = "Dancer", Age = 2, Horns = true, IpAddress = IPAddress.Parse("127.0.0.1") }; var deer3 = new Deer { Name = "Prancer", Age = 1, Horns = false, IpAddress = IPAddress.Parse("127.0.0.1") }; var deer4 = new Deer { Name = "Vixen", Age = 1, Horns = true, IpAddress = IPAddress.Parse("127.0.0.1") }; var deer5 = new Deer { Name = "Comet", Age = 1, Horns = true, IpAddress = IPAddress.Parse("127.0.0.1") }; var deer6 = new Deer { Name = "Cupid", Age = 1, Horns = false, IpAddress = IPAddress.Parse("127.0.0.1") }; var deer7 = new Deer { Name = "Donder ", Age = 1, Horns = true, IpAddress = IPAddress.Parse("127.0.0.1") }; var deer8 = new Deer { Name = "Blitzen", Age = 1, Horns = true, IpAddress = IPAddress.Parse("127.0.0.1") }; context.Beavers.Add(beaver1); context.Beavers.Add(beaver2); context.Beavers.Add(beaver3); context.Beavers.Add(beaver4); context.Beavers.Add(beaver5); context.Crows.Add(crow1); context.Crows.Add(crow2); context.Crows.Add(crow3); context.Crows.Add(crow4); context.Crows.Add(crow5); context.Deers.Add(deer1); context.Deers.Add(deer2); context.Deers.Add(deer3); context.Deers.Add(deer4); context.Deers.Add(deer5); context.Deers.Add(deer6); context.Deers.Add(deer7); context.Deers.Add(deer8); #endregion #region Seed Many-to-many (Club) var club1 = new Club { Title = "TreesWorshipers", Animals = new List <Animal> { beaver1, beaver2, beaver3, beaver4, beaver5, crow4 }, Locations = new List <Location> { new() { Address = "North America" }, new() { Address = "Canada" }, new() { Address = "Russia" } } }; var club2 = new Club { Title = "CornLovers", Animals = new List <Animal> { crow1, crow2, crow3, crow4, crow5 }, Locations = new List <Location> { new() { Address = "Westeros" } } }; var club3 = new Club { Title = "ChristmasTeam", Animals = new List <Animal> { beaver1, beaver2, beaver3, beaver4, beaver5, crow1, crow2, crow3, crow4, crow5, deer1, deer2, deer3, deer4, deer5, deer6, deer7, deer8 }, Locations = new List <Location> { new() { Address = "North Pole" } } }; context.Clubs.Add(club1); context.Clubs.Add(club2); context.Clubs.Add(club3); #endregion #region Seed Grades var grade1 = new Grade { TheGrade = 5, Club = club1, Animal = beaver1 }; var grade2 = new Grade { TheGrade = 4, Club = club1, Animal = beaver2 }; var grade3 = new Grade { TheGrade = 3, Club = club1, Animal = beaver3 }; var grade4 = new Grade { TheGrade = 3, Club = club1, Animal = beaver4 }; var grade5 = new Grade { TheGrade = 2, Club = club1, Animal = beaver5 }; var grade6 = new Grade { TheGrade = 1, Club = club1, Animal = crow4 }; var grade7 = new Grade { TheGrade = 5, Club = club2, Animal = crow1 }; var grade8 = new Grade { TheGrade = 4.5, Club = club2, Animal = crow2 }; var grade9 = new Grade { TheGrade = 2.1, Club = club2, Animal = crow3 }; var grade10 = new Grade { TheGrade = 4.3, Club = club2, Animal = crow4 }; var grade27 = new Grade { TheGrade = 4.5, Club = club3, Animal = beaver1 }; var grade26 = new Grade { TheGrade = 4.5, Club = club3, Animal = beaver2 }; var grade25 = new Grade { TheGrade = 4.5, Club = club3, Animal = beaver3 }; var grade24 = new Grade { TheGrade = 4.5, Club = club3, Animal = beaver4 }; var grade23 = new Grade { TheGrade = 4.5, Club = club3, Animal = beaver5 }; var grade22 = new Grade { TheGrade = 4.5, Club = club3, Animal = crow1 }; var grade21 = new Grade { TheGrade = 3.5, Club = club3, Animal = crow2 }; var grade20 = new Grade { TheGrade = 2.5, Club = club3, Animal = crow3 }; var grade19 = new Grade { TheGrade = 1.5, Club = club3, Animal = crow4 }; var grade28 = new Grade { TheGrade = 4.9, Club = club3, Animal = crow5 }; var grade11 = new Grade { TheGrade = 4.8, Club = club3, Animal = deer1 }; var grade12 = new Grade { TheGrade = 4.7, Club = club3, Animal = deer2 }; var grade13 = new Grade { TheGrade = 4.6, Club = club3, Animal = deer3 }; var grade14 = new Grade { TheGrade = 4.5, Club = club3, Animal = deer4 }; var grade15 = new Grade { TheGrade = 4.4, Club = club3, Animal = deer5 }; var grade16 = new Grade { TheGrade = 4.3, Club = club3, Animal = deer6 }; var grade17 = new Grade { TheGrade = 4.2, Club = club3, Animal = deer7 }; var grade18 = new Grade { TheGrade = 4.1, Club = club3, Animal = deer8 }; context.Grades.Add(grade1); context.Grades.Add(grade2); context.Grades.Add(grade3); context.Grades.Add(grade4); context.Grades.Add(grade5); context.Grades.Add(grade6); context.Grades.Add(grade7); context.Grades.Add(grade8); context.Grades.Add(grade9); context.Grades.Add(grade10); context.Grades.Add(grade11); context.Grades.Add(grade12); context.Grades.Add(grade13); context.Grades.Add(grade14); context.Grades.Add(grade15); context.Grades.Add(grade16); context.Grades.Add(grade17); context.Grades.Add(grade18); context.Grades.Add(grade19); context.Grades.Add(grade20); context.Grades.Add(grade21); context.Grades.Add(grade22); context.Grades.Add(grade23); context.Grades.Add(grade24); context.Grades.Add(grade25); context.Grades.Add(grade26); context.Grades.Add(grade27); context.Grades.Add(grade28); #endregion #region Seed Jobs var job1 = new Job { Title = "Builder", Salary = 1, Animals = new List <Animal> { beaver1, beaver2, beaver3, beaver4, beaver5 } }; var job2 = new Job { Title = "Messenger", Salary = 10, Animals = new List <Animal> { crow1, crow2, crow3, crow4 } }; var job3 = new Job { Title = "Delivery", Salary = 100, Animals = new List <Animal> { deer1, deer2, deer3, deer4, deer5, deer6, deer7, deer8 } }; context.Jobs.Add(job1); context.Jobs.Add(job2); context.Jobs.Add(job3); #endregion #region Seed TPH (Food) var food1 = new NormalFood { Title = "Elm", Animal = beaver1, Taste = Taste.Normal }; var food2 = new VeganFood { Title = "Daphne laureola", Animal = beaver2, Calories = 100 }; var food3 = new VeganFood { Title = "Carpinus betulus", Animal = beaver3, Calories = 1001 }; var food4 = new VeganFood { Title = "Hornbeam", Animal = beaver4, Calories = 101 }; var food5 = new NormalFood { Title = "Pizza", Animal = beaver5, Taste = Taste.Excellent }; var food6 = new NormalFood { Title = "Steak", Animal = crow1, Taste = Taste.Excellent }; var food7 = new NormalFood { Title = "Meat", Animal = crow2, Taste = Taste.Good }; var food8 = new NormalFood { Title = "Pizza", Animal = crow3, Taste = Taste.VeryGood }; var food9 = new VeganFood { Title = "Corn", Animal = crow4, Calories = 1 }; var food10 = new NormalFood { Title = "Pizza", Animal = crow5, Taste = Taste.Normal }; var food11 = new VeganFood { Title = "Pizza", Animal = deer1, Calories = 10 }; var food12 = new VeganFood { Title = "Pizza", Animal = deer2, Calories = 10 }; var food13 = new VeganFood { Title = "Pizza", Animal = deer3, Calories = 10 }; var food14 = new VeganFood { Title = "Pizza", Animal = deer4, Calories = 10 }; var food15 = new VeganFood { Title = "Pizza", Animal = deer5, Calories = 10 }; var food16 = new VeganFood { Title = "Pizza", Animal = deer6, Calories = 10 }; var food17 = new NormalFood { Title = "Elves", Animal = deer7, Taste = Taste.Excellent }; var food18 = new VeganFood { Title = "Pizza", Animal = deer8, Calories = 10 }; context.Food.Add(food1); context.Food.Add(food2); context.Food.Add(food3); context.Food.Add(food4); context.Food.Add(food5); context.Food.Add(food6); context.Food.Add(food7); context.Food.Add(food8); context.Food.Add(food9); context.Food.Add(food10); context.Food.Add(food11); context.Food.Add(food12); context.Food.Add(food13); context.Food.Add(food14); context.Food.Add(food15); context.Food.Add(food16); context.Food.Add(food17); context.Food.Add(food18); #endregion #region Seed Many-to-many old style (Drawback) var drawback1 = new Drawback { Title = "Crowdy", Foods = new List <Food> { food1, food2, food3, food4, /*food5,*/ food6, food7, food8, food9, food10, food11, food12, food13, food14, food15, food16, food17, food18 }, Clubs = new List <Club> { club1, club2, club3 }, Consequence = new Consequence { Name = "Nervousness" } }; var drawback2 = new Drawback { Title = "Windy", Foods = new List <Food> { food1, food2, food3, food4, food5, food6, food7, food8, food9, food10, food11, food12, food13, food14, food15, food16, food17, food18 }, Clubs = new List <Club> { club1, club2, club3 }, Consequence = new Consequence { Name = "Teleportation to Land of Oz" } }; var drawback3 = new Drawback { Title = "Soggy", Foods = new List <Food> { food1, food2, food3, food4, food5, food6, food7, food8, food9, food10, food11, food12, food13, food14, food15, food16, food17, food18 }, Clubs = new List <Club> { club1, club2, club3 }, Consequence = new Consequence { Name = "Wet clothes" } }; var drawback4 = new Drawback { Title = "Hardy", Foods = new List <Food> { food1, food2, food3, food4, food5, food6, food7, food8, food9, food10, food11, food12, food13, food14, food15, food16, food17, food18 }, Clubs = new List <Club> { club1, club2, club3 }, Consequence = new Consequence { Name = "Sadness" } }; context.Drawbacks.Add(drawback1); context.Drawbacks.Add(drawback2); context.Drawbacks.Add(drawback3); context.Drawbacks.Add(drawback4); var jobDrawback1 = new JobDrawback { Job = job1, Drawback = drawback1 }; var jobDrawback2 = new JobDrawback { Job = job1, Drawback = drawback2 }; var jobDrawback3 = new JobDrawback { Job = job1, Drawback = drawback3 }; var jobDrawback4 = new JobDrawback { Job = job1, Drawback = drawback4 }; var jobDrawback5 = new JobDrawback { Job = job2, Drawback = drawback1 }; var jobDrawback6 = new JobDrawback { Job = job2, Drawback = drawback2 }; var jobDrawback7 = new JobDrawback { Job = job3, Drawback = drawback1 }; var jobDrawback8 = new JobDrawback { Job = job3, Drawback = drawback2 }; context.JobDrawbacks.Add(jobDrawback1); context.JobDrawbacks.Add(jobDrawback2); context.JobDrawbacks.Add(jobDrawback3); context.JobDrawbacks.Add(jobDrawback4); context.JobDrawbacks.Add(jobDrawback5); context.JobDrawbacks.Add(jobDrawback6); context.JobDrawbacks.Add(jobDrawback7); context.JobDrawbacks.Add(jobDrawback8); #endregion context.SaveChanges(); #region Seed Property Bags (Category, Product) var category1 = new Dictionary <string, object> { ["Name"] = "Beverages", ["FoodId"] = food1.Id }; context.Categories.Add(category1); context.SaveChanges(); var product1 = new Dictionary <string, object> { ["Name"] = "Product1", ["CategoryId"] = context.Categories.First()["Id"] }; context.Products.Add(product1); #endregion #region Seed Persons var person1 = new Person { Name = "BeaverPerson", AnimalsLoved = new List <Animal> { beaver1, beaver2, beaver3, beaver4, beaver5 }, AnimalsHated = new List <Animal> { deer1, deer2, deer3, deer4, deer5, deer6, deer7, deer8 } }; context.Persons.Add(person1); #endregion #region Seed Elves var elf1 = new Elf { Name = "Alabaster Snowball", Deer = deer1 }; var elf2 = new Elf { Name = "Bushy Evergreen", Deer = deer1 }; var elf3 = new Elf { Name = "Pepper Minstix", Deer = deer2 }; var elf4 = new Elf { Name = "Shinny Upatree", Deer = deer3 }; var elf5 = new Elf { Name = "Sugarplum Mary", Deer = deer4 }; var elf6 = new Elf { Name = "Wunorse Openslae", Deer = deer5 }; var elf7 = new Elf { Name = "Grinch", Deer = deer6 }; var elf8 = new Elf { Name = "Legolas", Deer = deer7 }; var elf9 = new Elf { Name = "Iorveth", Deer = deer8 }; context.Elves.Add(elf1); context.Elves.Add(elf2); context.Elves.Add(elf3); context.Elves.Add(elf4); context.Elves.Add(elf5); context.Elves.Add(elf6); context.Elves.Add(elf7); context.Elves.Add(elf8); context.Elves.Add(elf9); #endregion #region Seed AdditionaInfos var additionalInfo1 = new AdditionalInfo() { Clubs = new List <Club>() { club1, club2, club3 }, Comment = "Best club ever" }; var additionalInfo2 = new AdditionalInfo() { Clubs = new List <Club>() { club1, club2 }, Comment = "Evolution club" }; var additionalInfo3 = new AdditionalInfo() { Clubs = new List <Club>() { club1 }, Comment = "Original club" }; context.AdditionalInfos.Add(additionalInfo1); context.AdditionalInfos.Add(additionalInfo2); context.AdditionalInfos.Add(additionalInfo3); #endregion context.SaveChanges(); context.Database.ExecuteSqlRaw(File.ReadAllText(".\\BD\\CreateTVF.sql")); }
private static void SeedDb() { using var context = new AnimalContext(); context.Database.Delete(); context.Database.Create(); #region Seed TPT (Animal) var beaver1 = new Beaver { Name = "SomeBeavers1", Age = 27, Fluffiness = FluffinessEnum.VeryFluffy, Size = 15, IpAddress = "127.0.0.1" }; var beaver2 = new Beaver { Name = "SomeBeavers2", Age = 26, Fluffiness = FluffinessEnum.Fluffy, Size = 14, IpAddress = "127.0.0.1" }; var beaver3 = new Beaver { Name = "SomeBeavers3", Age = 25, Fluffiness = FluffinessEnum.NotFluffy, Size = 13, IpAddress = "127.0.0.1" }; var beaver4 = new Beaver { Name = "SomeBeavers4", Age = 24, Fluffiness = FluffinessEnum.Fluffy, Size = 12, IpAddress = "127.0.0.1" }; var beaver5 = new Beaver { Name = "SomeBeavers5", Age = 23, Fluffiness = FluffinessEnum.VeryFluffy, Size = 11, IpAddress = "127.0.0.1" }; var crow1 = new Crow { Name = "Crowly", Age = 5, Color = "black", Size = 1, IpAddress = "127.0.0.1" }; var crow2 = new Crow { Name = "Crowly1", Age = 5, Color = "black", Size = 1, IpAddress = "127.0.0.1" }; var crow3 = new Crow { Name = "Crowly2", Age = 22, Color = "black", Size = 4, IpAddress = "127.0.0.1" }; var crow4 = new Crow { Name = "Crowly3", Age = 50, Color = "white", Size = 10, IpAddress = "127.0.0.1" }; var crow5 = new Crow { Name = "Crowly4", Age = 5, Color = "pink", Size = 1, IpAddress = "127.0.0.1" }; var deer1 = new Deer { Name = "Dasher", Age = 1, Horns = true, IpAddress = "127.0.0.1" }; var deer2 = new Deer { Name = "Dancer", Age = 2, Horns = true, IpAddress = "127.0.0.1" }; var deer3 = new Deer { Name = "Prancer", Age = 1, Horns = false, IpAddress = "127.0.0.1" }; var deer4 = new Deer { Name = "Vixen", Age = 1, Horns = true, IpAddress = "127.0.0.1" }; var deer5 = new Deer { Name = "Comet", Age = 1, Horns = true, IpAddress = "127.0.0.1" }; var deer6 = new Deer { Name = "Cupid", Age = 1, Horns = false, IpAddress = "127.0.0.1" }; var deer7 = new Deer { Name = "Donder ", Age = 1, Horns = true, IpAddress = "127.0.0.1" }; var deer8 = new Deer { Name = "Blitzen", Age = 1, Horns = true, IpAddress = "127.0.0.1" }; context.Beavers.Add(beaver1); context.Beavers.Add(beaver2); context.Beavers.Add(beaver3); context.Beavers.Add(beaver4); context.Beavers.Add(beaver5); context.Crows.Add(crow1); context.Crows.Add(crow2); context.Crows.Add(crow3); context.Crows.Add(crow4); context.Crows.Add(crow5); context.Deers.Add(deer1); context.Deers.Add(deer2); context.Deers.Add(deer3); context.Deers.Add(deer4); context.Deers.Add(deer5); context.Deers.Add(deer6); context.Deers.Add(deer7); context.Deers.Add(deer8); #endregion #region Seed Many-to-many (Club) var club1 = new Club { Title = "TreesWorshipers", Animals = new List <Animal> { beaver1, beaver2, beaver3, beaver4, beaver5, crow4 }, Locations = new List <Location> { new() { Address = "North America", GeographicLocation = DbGeography.FromText("POINT(-122 47)") }, new() { Address = "Canada", GeographicLocation = DbGeography.FromText("POINT(122 40)") }, new() { Address = "Russia", GeographicLocation = DbGeography.FromText("POINT(1 1)") } } }; var club2 = new Club { Title = "CornLovers", Animals = new List <Animal> { crow1, crow2, crow3, crow4, crow5 }, Locations = new List <Location> { new() { Address = "Westeros", GeographicLocation = DbGeography.FromText("POINT(00 00)") } } }; var club3 = new Club { Title = "ChristmasTeam", Animals = new List <Animal> { beaver1, beaver2, beaver3, beaver4, beaver5, crow1, crow2, crow3, crow4, crow5, deer1, deer2, deer3, deer4, deer5, deer6, deer7, deer8 }, Locations = new List <Location> { new() { Address = "North Pole", GeographicLocation = DbGeography.FromText("POINT(9 9)") } } }; context.Clubs.Add(club1); context.Clubs.Add(club2); context.Clubs.Add(club3); #endregion #region Seed Grades var grade1 = new Grade { TheGrade = 5, Club = club1, Animal = beaver1 }; var grade2 = new Grade { TheGrade = 4, Club = club1, Animal = beaver2 }; var grade3 = new Grade { TheGrade = 3, Club = club1, Animal = beaver3 }; var grade4 = new Grade { TheGrade = 3, Club = club1, Animal = beaver4 }; var grade5 = new Grade { TheGrade = 2, Club = club1, Animal = beaver5 }; var grade6 = new Grade { TheGrade = 1, Club = club1, Animal = crow4 }; var grade7 = new Grade { TheGrade = 5, Club = club2, Animal = crow1 }; var grade8 = new Grade { TheGrade = 4.5, Club = club2, Animal = crow2 }; var grade9 = new Grade { TheGrade = 2.1, Club = club2, Animal = crow3 }; var grade10 = new Grade { TheGrade = 4.3, Club = club2, Animal = crow4 }; var grade27 = new Grade { TheGrade = 4.5, Club = club3, Animal = beaver1 }; var grade26 = new Grade { TheGrade = 4.5, Club = club3, Animal = beaver2 }; var grade25 = new Grade { TheGrade = 4.5, Club = club3, Animal = beaver3 }; var grade24 = new Grade { TheGrade = 4.5, Club = club3, Animal = beaver4 }; var grade23 = new Grade { TheGrade = 4.5, Club = club3, Animal = beaver5 }; var grade22 = new Grade { TheGrade = 4.5, Club = club3, Animal = crow1 }; var grade21 = new Grade { TheGrade = 3.5, Club = club3, Animal = crow2 }; var grade20 = new Grade { TheGrade = 2.5, Club = club3, Animal = crow3 }; var grade19 = new Grade { TheGrade = 1.5, Club = club3, Animal = crow4 }; var grade28 = new Grade { TheGrade = 4.9, Club = club3, Animal = crow5 }; var grade11 = new Grade { TheGrade = 4.8, Club = club3, Animal = deer1 }; var grade12 = new Grade { TheGrade = 4.7, Club = club3, Animal = deer2 }; var grade13 = new Grade { TheGrade = 4.6, Club = club3, Animal = deer3 }; var grade14 = new Grade { TheGrade = 4.5, Club = club3, Animal = deer4 }; var grade15 = new Grade { TheGrade = 4.4, Club = club3, Animal = deer5 }; var grade16 = new Grade { TheGrade = 4.3, Club = club3, Animal = deer6 }; var grade17 = new Grade { TheGrade = 4.2, Club = club3, Animal = deer7 }; var grade18 = new Grade { TheGrade = 4.1, Club = club3, Animal = deer8 }; context.Grades.Add(grade1); context.Grades.Add(grade2); context.Grades.Add(grade3); context.Grades.Add(grade4); context.Grades.Add(grade5); context.Grades.Add(grade6); context.Grades.Add(grade7); context.Grades.Add(grade8); context.Grades.Add(grade9); context.Grades.Add(grade10); context.Grades.Add(grade11); context.Grades.Add(grade12); context.Grades.Add(grade13); context.Grades.Add(grade14); context.Grades.Add(grade15); context.Grades.Add(grade16); context.Grades.Add(grade17); context.Grades.Add(grade18); context.Grades.Add(grade19); context.Grades.Add(grade20); context.Grades.Add(grade21); context.Grades.Add(grade22); context.Grades.Add(grade23); context.Grades.Add(grade24); context.Grades.Add(grade25); context.Grades.Add(grade26); context.Grades.Add(grade27); context.Grades.Add(grade28); #endregion #region Seed Jobs var job1 = new Job { Title = "Builder", Salary = 1, Animals = new List <Animal> { beaver1, beaver2, beaver3, beaver4, beaver5 } }; var job2 = new Job { Title = "Messenger", Salary = 10, Animals = new List <Animal> { crow1, crow2, crow3, crow4 } }; var job3 = new Job { Title = "Delivery", Salary = 100, Animals = new List <Animal> { deer1, deer2, deer3, deer4, deer5, deer6, deer7, deer8 } }; context.Jobs.Add(job1); context.Jobs.Add(job2); context.Jobs.Add(job3); #endregion #region Seed TPH (Food) var food1 = new NormalFood { Title = "Elm", Animal = beaver1, Taste = Taste.Normal }; var food2 = new VeganFood { Title = "Daphne laureola", Animal = beaver2, Calories = 100 }; var food3 = new VeganFood { Title = "Carpinus betulus", Animal = beaver3, Calories = 1001 }; var food4 = new VeganFood { Title = "Hornbeam", Animal = beaver4, Calories = 101 }; var food5 = new NormalFood { Title = "Pizza", Animal = beaver5, Taste = Taste.Excellent }; var food6 = new NormalFood { Title = "Steak", Animal = crow1, Taste = Taste.Excellent }; var food7 = new NormalFood { Title = "Meat", Animal = crow2, Taste = Taste.Good }; var food8 = new NormalFood { Title = "Pizza", Animal = crow3, Taste = Taste.VeryGood }; var food9 = new VeganFood { Title = "Corn", Animal = crow4, Calories = 1 }; var food10 = new NormalFood { Title = "Pizza", Animal = crow5, Taste = Taste.Normal }; var food11 = new VeganFood { Title = "Pizza", Animal = deer1, Calories = 10 }; var food12 = new VeganFood { Title = "Pizza", Animal = deer2, Calories = 10 }; var food13 = new VeganFood { Title = "Pizza", Animal = deer3, Calories = 10 }; var food14 = new VeganFood { Title = "Pizza", Animal = deer4, Calories = 10 }; var food15 = new VeganFood { Title = "Pizza", Animal = deer5, Calories = 10 }; var food16 = new VeganFood { Title = "Pizza", Animal = deer6, Calories = 10 }; var food17 = new NormalFood { Title = "Elves", Animal = deer7, Taste = Taste.Excellent }; var food18 = new VeganFood { Title = "Pizza", Animal = deer8, Calories = 10 }; context.Food.Add(food1); context.Food.Add(food2); context.Food.Add(food3); context.Food.Add(food4); context.Food.Add(food5); context.Food.Add(food6); context.Food.Add(food7); context.Food.Add(food8); context.Food.Add(food9); context.Food.Add(food10); context.Food.Add(food11); context.Food.Add(food12); context.Food.Add(food13); context.Food.Add(food14); context.Food.Add(food15); context.Food.Add(food16); context.Food.Add(food17); context.Food.Add(food18); #endregion #region Seed Many-to-many old style (Drawback) var drawback1 = new Drawback { Title = "Crowdy", Foods = new List <Food> { food1, food2, food3, food4, /*food5,*/ food6, food7, food8, food9, food10, food11, food12, food13, food14, food15, food16, food17, food18 }, Clubs = new List <Club> { club1, club2, club3 }, Consequence = new Consequence { Name = "Nervousness" }, DrawbackDetail = new DrawbackDetails { DateCreated = DateTime.Now, Description = "the quality or state of being nervous" } }; var drawback2 = new Drawback { Title = "Windy", Foods = new List <Food> { food1, food2, food3, food4, food5, food6, food7, food8, food9, food10, food11, food12, food13, food14, food15, food16, food17, food18 }, Clubs = new List <Club> { club1, club2, club3 }, Consequence = new Consequence { Name = "Teleportation to Land of Oz" }, DrawbackDetail = new DrawbackDetails { DateCreated = DateTime.Now, Description = "hallucination" } }; var drawback3 = new Drawback { Title = "Soggy", Foods = new List <Food> { food1, food2, food3, food4, food5, food6, food7, food8, food9, food10, food11, food12, food13, food14, food15, food16, food17, food18 }, Clubs = new List <Club> { club1, club2, club3 }, Consequence = new Consequence { Name = "Wet clothes" }, DrawbackDetail = new DrawbackDetails { DateCreated = DateTime.Now, Description = "cold" } }; var drawback4 = new Drawback { Title = "Hardy", Foods = new List <Food> { food1, food2, food3, food4, food5, food6, food7, food8, food9, food10, food11, food12, food13, food14, food15, food16, food17, food18 }, Clubs = new List <Club> { club1, club2, club3 }, Consequence = new Consequence { Name = "Sadness" }, DrawbackDetail = new DrawbackDetails { DateCreated = DateTime.Now, Description = "the condition or quality of being sad" } }; context.Drawbacks.Add(drawback1); context.Drawbacks.Add(drawback2); context.Drawbacks.Add(drawback3); context.Drawbacks.Add(drawback4); var jobDrawback1 = new JobDrawback { Job = job1, Drawback = drawback1 }; var jobDrawback2 = new JobDrawback { Job = job1, Drawback = drawback2 }; var jobDrawback3 = new JobDrawback { Job = job1, Drawback = drawback3 }; var jobDrawback4 = new JobDrawback { Job = job1, Drawback = drawback4 }; var jobDrawback5 = new JobDrawback { Job = job2, Drawback = drawback1 }; var jobDrawback6 = new JobDrawback { Job = job2, Drawback = drawback2 }; var jobDrawback7 = new JobDrawback { Job = job3, Drawback = drawback1 }; var jobDrawback8 = new JobDrawback { Job = job3, Drawback = drawback2 }; context.JobDrawbacks.Add(jobDrawback1); context.JobDrawbacks.Add(jobDrawback2); context.JobDrawbacks.Add(jobDrawback3); context.JobDrawbacks.Add(jobDrawback4); context.JobDrawbacks.Add(jobDrawback5); context.JobDrawbacks.Add(jobDrawback6); context.JobDrawbacks.Add(jobDrawback7); context.JobDrawbacks.Add(jobDrawback8); #endregion #region Seed Persons var person1 = new Person { Name = "BeaverPerson", AnimalsLoved = new List <Animal> { beaver1, beaver2, beaver3, beaver4, beaver5 }, AnimalsHated = new List <Animal> { deer1, deer2, deer3, deer4, deer5, deer6, deer7, deer8 } }; context.Persons.Add(person1); #endregion context.SaveChanges(); }