I have an old code base with 2 Entity classes (suppose with 10 measure). Old Functionality work like whenever u upload a Excel file it gonna parse the file and map to these entity class. Now as per new requirements Every year I am getting more measure added to these entity classes and getting new Excel file with 5 measure. How can I add versioning based on every year or how can I do mapping to the entity class every year from only one base Entity Class. Or how can I introduce this functionality without changing the design
Example of entity class-
[DataColumnAttribute]
public StatusLkup Insurance { get; set; }
[DataColumnAttribute]
public Code Status { get; set; }
[DataColumnAttribute]
public string test1 { get; set; }
Example of Excel file
Row 1 - Insurance, states, test1 Row 2 - 5, Co, test
Next year suppose 2 more new measure added to an entity class
[DataColumnAttribute]
public StatusLkup Insurance { get; set; }
[DataColumnAttribute]
public Code Status { get; set; }
[DataColumnAttribute]
public string test1 { get; set; }
[DataColumnAttribute]
public string test2 { get; set; }
[DataColumnAttribute]
public string test3 { get; set; }
Next year excel file
Row 1 - test1, test2 Row 2 - 12, 11