Hey Guys,
I am looking to find the best way to cache the DB Lookup Tables which consists of about 75 table.
I want to cache these tables data to use them in my application so i won't open a connection with the DB each time i need them.
so Here is what i am doing:
1- i have created i static class contains static properties to each lookup table called (MyApplicatioCache).
2- each property in (get) i am filling it with the intended data from DB.
3- Put the result in HttpRuntime.Cache["PropertyName"]
4- each time i GET this lookup table data i make a check if the HttpRuntime.Cache["PropertyName"] Not equal Null.
5- if yes then i am getting it from cahce else i am getting it fro ...
Go to the complete details ...