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