protected override void Seed(ContinentsDbContext context) { var existingContinents = context.Continents.FirstOrDefault(); if (existingContinents == null) { this.SeedLanguages(context, 20); this.SeedContinents(context); this.SeedCountries(context, 200); this.SeedTowns(context, 2000); } }
private void SeedLanguages(ContinentsDbContext context, int count) { for (int i = 0; i < count; i++) { var language = new Language { Name = this.random.GetRandomStringWithRandomLength(5, 15) }; context.Languages.Add(language); } context.SaveChanges(); }
private void SeedContinents(ContinentsDbContext context) { var continents = new[] { "Europe", "Africa", "Asia", "South America", "North America", "Australia", "Antartica" }; for (int i = 0; i < continents.Length; i++) { var continent = new Continent { Name = continents[i] }; context.Continents.Add(continent); } context.SaveChanges(); }
private void SeedTowns(ContinentsDbContext context, int count) { var countriesCount = context.Countries.Count(); for (int i = 0; i < count; i++) { var town = new Town { Name = this.random.GetRandomStringWithRandomLength(5, 15), Population = this.random.GetRandomNumber(100000, 100000000), CountryId = this.random.GetRandomNumber(1, countriesCount), }; context.Towns.Add(town); } context.SaveChanges(); }
private void SeedCountries(ContinentsDbContext context, int count) { var languagesCount = context.Languages.Count(); for (int i = 0; i < count; i++) { var country = new Country { Name = this.random.GetRandomStringWithRandomLength(5, 15), Population = this.random.GetRandomNumber(100000, 100000000), LanguageId = this.random.GetRandomNumber(1, languagesCount), ContinentId = this.random.GetRandomNumber(1, 7), }; context.Countries.Add(country); } context.SaveChanges(); }
static void Main(string[] args) { var context = new ContinentsDbContext(); context.Continents.FirstOrDefault(); }
protected void Page_Load(object sender, EventArgs e) { this.db = new ContinentsDbContext(); }