Hello ,

I have a web application in which i cache the tables in dataset/hastables (in particular class) frequently required data.

The problem is this that if data is not in cache and two simultaneous requests come then both these requests go through DAL to database. I have implemented dal method like this that it checks for existing request placed by name of procedure, but still it is unable to block other requests.

any help or suggestion would be appreciated

thanks