static void Main(string[] args) { games = new Games(); var urls = new List<string>(); urls.Add("http://www.gamefaqs.com/XBOX360/list-a"); urls.Add("http://www.gamefaqs.com/XBOX360/list-b"); urls.Add("http://www.gamefaqs.com/XBOX360/list-c"); urls.Add("http://www.gamefaqs.com/XBOX360/list-d"); urls.Add("http://www.gamefaqs.com/XBOX360/list-e"); urls.Add("http://www.gamefaqs.com/XBOX360/list-f"); urls.Add("http://www.gamefaqs.com/XBOX360/list-g"); urls.Add("http://www.gamefaqs.com/XBOX360/list-h"); urls.Add("http://www.gamefaqs.com/XBOX360/list-i"); urls.Add("http://www.gamefaqs.com/XBOX360/list-j"); urls.Add("http://www.gamefaqs.com/XBOX360/list-k"); urls.Add("http://www.gamefaqs.com/XBOX360/list-l"); urls.Add("http://www.gamefaqs.com/XBOX360/list-m"); urls.Add("http://www.gamefaqs.com/XBOX360/list-n"); urls.Add("http://www.gamefaqs.com/XBOX360/list-o"); urls.Add("http://www.gamefaqs.com/XBOX360/list-p"); urls.Add("http://www.gamefaqs.com/XBOX360/list-q"); urls.Add("http://www.gamefaqs.com/XBOX360/list-r"); urls.Add("http://www.gamefaqs.com/XBOX360/list-s"); urls.Add("http://www.gamefaqs.com/XBOX360/list-t"); urls.Add("http://www.gamefaqs.com/XBOX360/list-u"); urls.Add("http://www.gamefaqs.com/XBOX360/list-v"); urls.Add("http://www.gamefaqs.com/XBOX360/list-w"); urls.Add("http://www.gamefaqs.com/XBOX360/list-x"); urls.Add("http://www.gamefaqs.com/XBOX360/list-y"); urls.Add("http://www.gamefaqs.com/XBOX360/list-z"); urls.Add("http://www.gamefaqs.com/XBOX360/list-0"); foreach (string url in urls) { try { ProcessGameLetter(url, 0); } catch (Exception ex) { Console.Write(ex.Message); } Console.WriteLine("Done: " + url.Replace("http://www.gamefaqs.com", "")); } Console.WriteLine("Done."); Console.Read(); }
private void SeedGame(string name, object userId) { Games games = new Games(); var console = "XBOX360"; var tokens = name.Split(new string[] { "|" }, StringSplitOptions.None); if (tokens.Length == 2) { name = tokens.First(); console = tokens.Last(); } var game = games.SingleWhere("Name = @0", name); object gameId = null; if (game == null) gameId = new { name, console }.InsertInto("Games"); else gameId = game.Id; new { userId, gameId }.InsertInto("Library"); }