What is sqlCacheDependency?

Can anyone tell me what this block of code below means? What it's used for? Why have it there?

	<sqlCacheDependency enabled="true" pollTime="1000">
			<add name="Pubs" connectionStringName="Pubs"/>

Open in new window

John AccountAsked:
Who is Participating?
hismightinessConnect With a Mentor Commented:
That sections allows ASP.Net to work in conjunction with the SQL Server to provide caching of data on-the-fly.  This results in a faster application for the end-user, but more processing time on the server.
To be more specific, the data in the location specified in the Pubs connection string is cached for 1000 seconds, and this dependency is enabled right now.
ZeonFlashConnect With a Mentor Commented:
It basically watches the database to see if there are any changes made, and if so, invalidates the cache.

John AccountAuthor Commented:
Thanks, guys. I appreciate it very much!
All Courses

From novice to tech pro — start learning today.