private SQLMultiInsert GetInsertHelper(IDbConnection conn, string tableName) { SQLMultiInsert helper = new SQLMultiInsert(conn, tableName, MAX_RECORDS_PER_QUERY); helper.InsertCommand = "Insert or replace"; helper.AddField("ID", DbType.Int64, 0); helper.AddField("Symbol", DbType.String, 255); helper.AddField("Time", DbType.Int64, 0); helper.AddField("Bid", DbType.Double, 0); helper.AddField("Ask", DbType.Double, 0); helper.AddField("BidSize", DbType.Int32, 0); helper.AddField("AskSize", DbType.Int32, 0); helper.AddField("Provider", DbType.String, 255); helper.Prepare(); return(helper); }
protected virtual SQLMultiInsert GetInsertHelper(IDbConnection conn) { SQLMultiInsert helper = new SQLMultiInsert(conn, CollectionName, InsertsPerQuery); helper.InsertCommand = "replace"; // the old row is deleted before the new row is inserted helper.AddField("ID", DbType.Int64, 0); helper.AddField("Symbol", DbType.String, 255); helper.AddField("Time", DbType.DateTime, 0); helper.AddField("Bid", DbType.Double, 0); helper.AddField("Ask", DbType.Double, 0); helper.AddField("BidSize", DbType.Int32, 0); helper.AddField("AskSize", DbType.Int32, 0); helper.AddField("Provider", DbType.String, 255); helper.Prepare(); return(helper); }
protected virtual SQLMultiInsert GetInsertHelper(IDbConnection conn) { SQLMultiInsert helper = new SQLMultiInsert(conn, CollectionName, InsertsPerQuery); helper.InsertCommand = "replace"; // the old row is deleted before the new row is inserted helper.AddField("ID", DbType.Int64, 0); helper.AddField("Symbol", DbType.String, 255); helper.AddField("Time", DbType.DateTime, 0); helper.AddField("Bid", DbType.Double, 0); helper.AddField("Ask", DbType.Double, 0); helper.AddField("BidSize", DbType.Int32, 0); helper.AddField("AskSize", DbType.Int32, 0); helper.AddField("Provider", DbType.String, 255); helper.Prepare(); return helper; }
private SQLMultiInsert GetInsertHelper(IDbConnection conn, string tableName) { SQLMultiInsert helper = new SQLMultiInsert(conn, tableName, MAX_RECORDS_PER_QUERY); helper.InsertCommand = "Insert or replace"; helper.AddField("ID", DbType.Int64, 0); helper.AddField("Symbol", DbType.String, 255); helper.AddField("Time", DbType.Int64, 0); helper.AddField("Bid", DbType.Double, 0); helper.AddField("Ask", DbType.Double, 0); helper.AddField("BidSize", DbType.Int32, 0); helper.AddField("AskSize", DbType.Int32, 0); helper.AddField("Provider", DbType.String, 255); helper.Prepare(); return helper; }