Posted on: 3/19/2014 9:40:30 AM | Views : 572

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 ...