public ActionResult Index() { ReceiptDataContext dc = new ReceiptDataContext(); var companies = dc.Companies .Select(c => new CompanyViewModel { CompanyId = c.CompanyId, Name = c.Name, City = c.City, Address = c.Address, Eik = c.Bulstat, Description = c.Description, hasReceipt = c.Receipts.Count() > 0 }) .ToList(); return(View(companies)); }