public AuctionLoader(string connstr, string apikey, string realmname) { _connstr = connstr; _conn = new SqlConnection(_connstr); _conn.Open(); _explorer = new WowExplorer(Region.US, Locale.en_US, apikey); _af = _explorer.GetAuctionFiles(realmname); _ah = _explorer.GetAuctions(realmname); _dt = new DataTable(); _dt.Columns.Add("ID"); _dt.Columns.Add("ItemID"); _dt.Columns.Add("Owner"); _dt.Columns.Add("Bid"); _dt.Columns.Add("BuyOut"); _dt.Columns.Add("Quantity"); _dt.Columns.Add("TimeLeft"); _dt.Columns.Add("LoadDate"); _dt.Columns["LoadDate"].DataType = typeof(DateTime); _dateTimeOffset = DateTimeOffset.FromUnixTimeMilliseconds(_af.Files.Take(1).Select(x => x.LastModified).ToArray()[0]); _dt.Columns["LoadDate"].DefaultValue = _dateTimeOffset.DateTime; }