public ActionResult Allocations() { ViewBag.Message = "Your project allocation page."; var allocations = _repo.GetAllocation(); var allocationsList = new List <AllocationDTO>(); foreach (var allocation in allocations) { var users = _repo.GetUsers().Where(u => u.Id == allocation.UsersId).FirstOrDefault(); var projects = _repo.GetProjects().Where(p => p.Id == allocation.ProjectsId).FirstOrDefault(); //data transfer object allocationsList.Add(new AllocationDTO() { Username = users.Username, ProjectName = projects.ProjectName }); } return(View(allocationsList)); }