public static void Setup() { Database.SetInitializer(new DropCreateDatabaseAlways<CountryContext>()); CountryContext context = new CountryContext(); //just load up somthing to initialise context.Countries.ToList(); }
private static void AddCountries(XElement countryList, CountryContext context) { foreach (var country in context.Countries) { XElement xCountry = new XElement("country"); xCountry.Add(new XAttribute("name", country.EnglishName)); AddVariants(xCountry, country); countryList.Add(xCountry); } }
private static void Main(string[] args) { using (CountryContext context = new CountryContext()) { Console.WriteLine("Starting COUNTREE outputterator..."); XDocument countryList = new XDocument(); countryList.Add(new XElement("countries")); AddCountries(countryList.Root, context); SaveToLocalFile(countryList); Console.WriteLine("Done - Hit <ENTER>"); Console.ReadLine(); } }
private static void Main(string[] args) { Console.WriteLine("Starting"); Console.WriteLine("Set up database"); Bootstrapper.Setup(); Console.WriteLine("Finished"); using (CountryContext countryContext = new CountryContext()) { try { IHtmlService service = new HtmlService(); foreach (var site in Sitelist) { Console.WriteLine("Loading up page: " + site); HtmlDocument webpage = service.GetWebPage(site); Console.WriteLine("Got website"); Console.WriteLine("Strip countries..."); var countries = CountryStripper.GetCountries(webpage); Console.WriteLine("Stripped"); foreach (Country country in countries) { Console.WriteLine(string.Format("Country: {0}", country.EnglishName)); countryContext.Countries.Add(country); } Console.WriteLine("Start Save"); countryContext.SaveChanges(); Console.WriteLine("Saved!"); } } catch (Exception ex) { Console.WriteLine(); Console.Write(ex); Console.WriteLine(); } Console.WriteLine(); Console.WriteLine("STATS"); Console.WriteLine("-------------------"); Console.WriteLine("Countries: " + countryContext.Countries.Count()); Console.WriteLine("Language Sets: " + countryContext.LanguageSets.Count()); Console.WriteLine("Languages: " + countryContext.Languages.Count()); } Console.WriteLine("Press enter to close"); Console.ReadLine(); }