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);
}
