You have an enumeration:
public enum ISO639Code { Afrikaans = 1, Albanian = 2, Amharic = 3,
and etc.
Create database table:
ISO639Id int PK, ISO639Code char(2)
If ISO639Id matches the enumeration value.
In the code, you need the ISO630 class, which contains identifier and code values ββread from the database. (You can load this once and then cache it in memory.)
The beauty of this approach is that it can be easily extended, so if in the future you want to store more information for each ISO639 code, you can simply add another field.
Bonyt
source share