What is SQL Cache Dependency in ASP.NET?

What is SQL Cache Dependency in ASP.NET?

- It is the mechanism where the cache object gets invalidated when the related data or the related resource is modified.

- It is a feature in SQL Server 2005 and SQL Server 2000.

There are three types of SQL-cache dependencies exist:

1. Other cache items.
2. Files / folders.
3. Dependencies on a database query.

- It can be used for both the application cache and the page output cache.

- It is used in a web garden (multiple processors on one version) or a web form (multiple servers running the same application).

- There is no need to have SQL knowledge to configure SQL cache dependency in your application and in SQL server.

- It is the simplest way to balance the performance gains of caching against data staleness.
Concepts of Post Cache Substitution in .NET
Concepts of Post Cache Substitution in .NET - It works opposite to fragment caching. The entire page is cached, except what is to be kept dynamic..
Explain the use of localization and Globalization
Use of localization and Globalization - users of different countries, use different languages and others settings like currency, and dates...
Concepts of CODE Page approach - ASP.NET
Concepts of CODE Page approach - Code Page was used before Unicode came into existence..
Post your comment