public async Task <IActionResult> Index() { var clients = await _context.Clients .Include(client => client.Stocks) .ToListAsync(); if (clients.Count == 0) { var clientData = ClientData(); await _context.AddRangeAsync(clientData); await _context.SaveChangesAsync(); var generatedClients = await _context.Clients.ToListAsync(); var stockData = StockData(generatedClients); for (int i = 0; i < 5; i++) { stockData.AddRange(StockData(generatedClients)); } await _context.AddRangeAsync(stockData); await _context.SaveChangesAsync(); clients = await _context.Clients .Include(client => client.Stocks) .ToListAsync(); _logger.LogInformation("Created Sample Data."); } var homePage = new List <HomeViewModel>(); foreach (var client in clients) { homePage.Add(new HomeViewModel() { Id = client.Id, ClientFirstName = client.FirstName, ClientLastName = client.LastName, StockQuantity = client.Stocks.Count }); } return(View(homePage)); }