| Author: saravanakumar 04 Dec 2008 | Member Level: Gold | Rating:  Points: 1 |
hi monisha,
check this URl,
http://msdn.microsoft.com/en-us/library/system.web.caching.sqlcachedependency.aspx
regards,
saravan
|
| Author: raj 04 Dec 2008 | Member Level: Bronze | Rating: Points: 1 |
Hi ,
Check the following URL.
http://apnasaathi.blogspot.com/2006/11/cache.html
regards
..raj
|
| Author: Patel 04 Dec 2008 | Member Level: Silver | Rating: Points: 6 |
To utilize the new SQL Server Cache Dependency feature in ASP.NET 2.0, you must perform a one-time setup of your SQL Server database. To set up your SQL Server, use the aspnet_regsql.exe tool found at C:\Windows\Microsoft.NET\Framework\v2.0xxxxx\. This tool makes the necessary modifications to SQL Server so that you can start working with the new SQL cache invalidation features.
Follow these steps when using the new SQL Server Cache Dependency features:
Enable your database for SQL Cache Dependency support.
Enable a table or tables for SQL Cache Dependency support.
Include SQL connection string details in the ASP.NET application’s web.config.
Utilize the SQL Cache Dependency features in one of the following ways:
Programmatically create a SqlCacheDependency object in code.
Add a SqlDependency attribute to an OutputCache directive.
Add a SqlCacheDependency instance to the Response object via Response.AddCacheDependency.
aspnet_regsql.exe -?
This code outputs the help command list for this command-line tool, as shown in the following:
-- SQL CACHE DEPENDENCY OPTIONS --
-d <database> Database name for use with SQL cache dependency. The
database can optionally be specified using the
connection string with the -c option instead.
(Required)
-ed Enable a database for SQL cache dependency.
-dd Disable a database for SQL cache dependency.
-et Enable a table for SQL cache dependency. Requires -t
option.
-dt Disable a table for SQL cache dependency. Requires -t
option.
-t <table> Name of the table to enable or disable for SQL cache
dependency. Requires -et or -dt option.
-lt List all tables enabled for SQL cache dependency.
|
| Author: Deepika Haridas 04 Dec 2008 | Member Level: Diamond | Rating: Points: 2 |
Hi,
Check out this link
1) http://www.asp.net/learn/data-access/tutorial-61-cs.aspx
2) http://www.dotnetspider.com/resources/18424-Using-SQLCacheDependency-Class-ASP-Net-SQL-server.aspx
3) http://www.ondotnet.com/pub/a/dotnet/2005/01/17/sqlcachedependency.html
regards,
deepika
Thanks & Regards,
Deepika
Editor
If U want to shine like a SUN..First U have to burn like the SUN!!
Need a Guide? Join my mentor program..
|