public int AddCompaniesToList(List <CompanyInformation> list) { using (var db = new StockDataContext()) { db.companyInformation.AddRange(list); // Return the number of companies added to list return(db.SaveChanges()); } }
public int AddDailyStockData(List <DailyStockData> stockData, List <CircuitBreaker> circuitBreaker, DateTime date) { var symIndMapping = getSymbolToIndustryMapping(); using (var db = new StockDataContext()) { db.stockData.AddRange(stockData); stockData.ForEach(x => x.industry = symIndMapping.TryGetValue(x.symbol, out string industry) ? industry : ConstValues.defaultIndustry); var sectorChange = stockData.GroupBy(x => x.industry) .Select(x => new SectorInformation(date, x.Key, x.Average(y => y.change))) .OrderBy(x => x.industry); db.sectorInformation.AddRange(sectorChange); if (circuitBreaker != null) { db.circuitBreaker.AddRange(circuitBreaker); } var count = db.SaveChanges(); Console.WriteLine("Added {0} rows while updating companies Stock Data for {1} ", count, date.ToString()); return(count); } }