public static void Seed(CustomersEntitiesDataContext context, int count, string rootPath) { var addresses = context.Customers.Select(x => x.Address).ToList(); var cities = context.Customers.Select(x => x.City).ToList(); var companynames = context.Customers.Select(x => x.CompanyName).ToList(); var contactnames = context.Customers.Select(x => x.ContactName).ToList(); var contacttitles = context.Customers.Select(x => x.ContactTitle).ToList(); var countries = context.Customers.Select(x => x.Country).ToList(); var faxes = context.Customers.Select(x => x.Fax).ToList(); var phones = context.Customers.Select(x => x.Phone).ToList(); var postalcodes = context.Customers.Select(x => x.PostalCode).ToList(); var random = new Random(); var lineOfText = ""; var filestream = new System.IO.FileStream(rootPath + "/cities.txt", System.IO.FileMode.Open, System.IO.FileAccess.Read, System.IO.FileShare.ReadWrite); var file = new System.IO.StreamReader(filestream, System.Text.Encoding.ASCII, true, 128); context.Database.ExecuteSqlCommand("delete from Customers"); while ((lineOfText = file.ReadLine()) != null) { cities.Add(lineOfText); } for (int i = 0; i < 50000; i++) { context.Customers.Add(new graphql_aspnet_core.Data.Entities.Customer { Address = addresses[random.Next(0, addresses.Count - 1)], City = cities[random.Next(0, 1000)], CompanyName = companynames[random.Next(0, companynames.Count - 1)] + " " + cities[random.Next(0, cities.Count - 1)], ContactName = contactnames[random.Next(0, contactnames.Count - 1)], ContactTitle = contacttitles[random.Next(0, contacttitles.Count - 1)], Country = countries[random.Next(0, countries.Count - 1)], Fax = faxes[random.Next(0, faxes.Count - 1)], Phone = phones[random.Next(0, phones.Count - 1)], PostalCode = phones[random.Next(0, phones.Count - 1)], CustomerID = Seeder.RandomString(15, random) }); } context.SaveChanges(); }