public void AddLastEmployeeNameToTickets() { using (var db = new OcecomTicketsContext()) { foreach (var ticket in db.Tickets.ToList()) { if (ticket.TicketHourRecords.Any()) { ticket.LastEmployeeName = ticket.TicketHourRecords.OrderBy(t => t.Date).Last().Employee.Name; } } db.SaveChanges(); } }