public async Task <IEnumerable <Stock> > GetStocksInFactory(int id) { var stocks = await _stocksRepository.GetStocksInFactory(id).ConfigureAwait(false); var items = await _itemsRepository.GetItems().ConfigureAwait(false); return(from stock in stocks join item in items on stock.ItemNumber equals item.ItemNumber select new Stock { Date = stock.Date, ItemNumber = stock.ItemNumber, Id = stock.Id, QtyPerBlade = item.QtyPerBlade, FactoryId = stock.FactoryId, ItemDescription = item.ItemDescription, Qty = stock.Qty }); }