public override IEnumerable <KeyValuePair <long, Tick> > Read()
{
var cmd = new ScimoreCommand("SELECT * FROM " + CollectionName + " [ORDER BY {ID} [ASC]];", (ScimoreConnection)connections[0]);
foreach (var row in cmd.ExecuteReader().Forward())
{
long key = row.GetInt64(0);
Tick tick = new Tick();
tick.Symbol = row.GetString(1);
tick.Timestamp = new DateTime(row.GetInt64(2));
tick.Bid = row.GetDouble(3);
tick.Ask = row.GetDouble(4);
tick.BidSize = row.GetInt32(5);
tick.AskSize = row.GetInt32(6);
tick.Provider = row.GetString(7);
yield return(new KeyValuePair <long, Tick>(key, tick));
}
}
public override IEnumerable<KeyValuePair<long, Tick>> Read()
{
var cmd = new ScimoreCommand("SELECT * FROM " + CollectionName + " [ORDER BY {ID} [ASC]];", (ScimoreConnection)connections[0]);
foreach (var row in cmd.ExecuteReader().Forward())
{
long key = row.GetInt64(0);
Tick tick = new Tick();
tick.Symbol = row.GetString(1);
tick.Timestamp = new DateTime(row.GetInt64(2));
tick.Bid = row.GetDouble(3);
tick.Ask = row.GetDouble(4);
tick.BidSize = row.GetInt32(5);
tick.AskSize = row.GetInt32(6);
tick.Provider = row.GetString(7);
yield return new KeyValuePair<long, Tick>(key, tick);
}
}
