SqDependency is ideal for caching scenarios, where your ASP.NET application or middle-tier service needs to keep certain information cached in memory. SqDependency allows you to receive notifications when the original data in the database changes so that the cache can be refreshed.