void SaveToDB() { var dh = new DatabaseDataProvider(); var connectionStr = ConfigurationManager.ConnectionStrings["MarketDataConnectionString"].ConnectionString; dh.GetDatabaseConnection = () => { return(new SqlConnection(connectionStr)); }; dh.DeleteBatch(null, "Table_TradePrice", new List <string>() { "Ticker,Time" }, MarketDataList.Cast <object>().ToList()); dh.InsertBatch(null, "Table_TradePrice", MarketDataList.Cast <object>().ToList()); }
public void WriteToDB(string connectionStr) { var dh = new DatabaseDataProvider(); dh.GetDatabaseConnection = () => CreateConnection(connectionStr); //dh.DeleteBatch(null, "marketminuteprice", "UID", MarketDataList.Cast<object>().ToList()); //dh.InsertBatch(null, "marketminuteprice", MarketDataList.Cast<object>().ToList()); var l = MarketDataList.Cast <object>().ToList(); if (LimitBeginTime != null) { l = MarketDataList.Where(v => v.Time > LimitBeginTime).Cast <object>().ToList(); } dh.DeleteBatch(null, "Table_TradePrice", new List <string>() { "Time", "Ticker" }, l); dh.InsertBatch(null, "Table_TradePrice", l); }