In a .Net c# application we are designing we have several tables with a small number of lookup values. For example we have a table Payment which has FKs to table Status (Complete, Pending, Refunded) and table Type (Cash, CreditCard, BankTransfer).
We are using Entitiframework 4.0 . The table Status and Type have very few entries that rarely change so I don't want to keep querying the DB over and over again for their values. What is the best way to cache the values so the entities can be smarter?