I have a requirement where I need to handle a set of tables with some smaller number of rows. And the chance of these rows getting updated is very low, So I don't want to visit the database now and then. Basically these tables are used to fill drop-downs on every pages.
I am thinking the way where put records in an application level dataset on application load event and use it across the application
Is this is right way to do this or there is some other way/technology where we may fulfill our requirement ?