I am using MVC with Entity Framework and I have a table that tracks daily events in a hotel atmosphere. These events change daily such as who cleans a room and the time of the cleaning. The table is fine as is but what I would like to do is to save a copy of the table on a daily basis. I have read in this forum that serializing a list of table entries is not a good idea (How to store a list in a column of a database table). How do I go about saving the table data on a daily basis if not using a list of the table entries?
This is my units class/table
    public class Units
{
    [Key]
    [Required]
    public int UnitId { get; set; }
    public int UnitNumber { get; set; }
    public string UnitType { get; set; }
    public string Status { get; set; }   
    public bool Checkout { get; set; }  
    public bool isEmpty { get; set; }           
    public Employees Housekeeper { get; set; }
    public DateTime? CleanStart { get; set; }
    public DateTime? CleanEnd { get; set; }
    public bool isClean { get; set; }
    public Employees Laundry { get; set; }
    public DateTime? LaundryTime { get; set; }
    public bool isLaundry { get; set; }
    public Employees QualityControl { get; set; }
    public DateTime? QCStart { get; set; }
    public DateTime? QCEnd { get; set; }
    public bool isQC { get; set; }
    public Employees Maintenance { get; set; }
    public DateTime? MaintStart { get; set; }
    public DateTime? MaintEnd { get; set; }
    public bool isMaint { get; set; }
    public string Comments { get; set; }
    public string Color { get; set; }
}
