public void SaveToDatabase_And_LoadFromDatabase() { // Arrange StockEngine engine = GetEngine(); List <Quote> stocks = new List <Quote>(); Quote stock1 = new Quote("SYM1") { Id = Guid.NewGuid(), LastTradePrice = 1.50m, }; Quote stock2 = new Quote("SYM2") { Id = Guid.NewGuid(), LastTradePrice = 2.50m }; stocks.Add(stock1); stocks.Add(stock2); // Act engine.InsertQuotes(stocks); List <Quote> stocksFromDb = engine.AllQuotes().ToList(); // Assert Assert.That(stocksFromDb.Count, Is.EqualTo(2)); Assert.That(stocksFromDb[0].Id, Is.EqualTo(stock1.Id)); Assert.That(stocksFromDb[0].LastTradePrice, Is.EqualTo(stock1.LastTradePrice)); Assert.That(stocksFromDb[0].Symbol, Is.EqualTo(stock1.Symbol)); Assert.That(stocksFromDb[1].Id, Is.EqualTo(stock2.Id)); Assert.That(stocksFromDb[1].LastTradePrice, Is.EqualTo(stock2.LastTradePrice)); Assert.That(stocksFromDb[1].Symbol, Is.EqualTo(stock2.Symbol)); }
public void Query300Symbols() { // Arrange StockEngine engine = GetEngine(); // Act IEnumerable <string> symbols = engine.LoadSymbolsFromTextFile("aim.txt"); IEnumerable <Quote> stocks = engine.LookupPrices(symbols.Take(300)); engine.InsertQuotes(stocks); List <Quote> stocksFromDb = engine.AllQuotes().ToList(); // Assert Assert.That(stocksFromDb.Count(), Is.GreaterThan(200)); }