I am making this a community wiki, as I would appreciate people's approach and not necessarily an answer.
I am in the situation where I have a lot of lookup type data fields, that do not change. An example would be:
Yearly Salary
Option: 0 - 25K
Option: 25K - 100K
Option: 100K +
I would like to have these options easily available through an enum, but would also like to textual values available in the DB, as I will do reporting on the textual values and not a ID. Also, since they are static I do not want to be making calls to the DB.
I was thinking duplicating this in an enum and table, but would like to hear some alternate thoughts.
Thanks