private static void GetMissingItems(string[] args) { using (SqlConnection sqlConn = new SqlConnection("Server=SPLITHPC;Database=master;Trusted_Connection=SSPI;")) { sqlConn.Open(); SqlCommand sqlComm = sqlConn.CreateCommand(); sqlComm.CommandText = @"SELECT i.ID FROM [WoWAuctionData].[dbo].[Items] i WHERE i.ID NOT IN (SELECT ID FROM [WoWAuctionDataTest].[dbo].[Items])"; WoWAuctionContext wac = new WoWAuctionContext(); var reader = sqlComm.ExecuteReader(); while (reader.Read()) { Int32 itemID = (Int32)reader.GetValue(0); var poller = new WoWAuctionPoller() { BaseAPI = "http://us.battle.net/api/wow", }; var currentItem = wac.Items.Create(); poller.PollItem(itemID, ref currentItem); wac.Items.Add(currentItem); } wac.SaveChanges(); } }
public void AuctionMetaDataConnection() { WoWAuctionPoller poller = new WoWAuctionPoller() { BaseAPI = "http://us.battle.net/api/wow", }; Debug.WriteLine("-- Starting Exerices --"); var stopwatch = new Stopwatch(); stopwatch.Start(); poller.QueryAuctions(ConfigurationManager.AppSettings["server"], ConfigurationManager.AppSettings["factions"].Split(',')); stopwatch.Stop(); Debug.WriteLine( String.Format("Operation took Hour:{0}, Minute:{1}, Second:{2}", stopwatch.Elapsed.Hours, stopwatch.Elapsed.Minutes, stopwatch.Elapsed.Seconds )); }