Asp.net uses SqlDependency To Cache Usage notes

Use SqlDependency cache in asp.net

1 first, you must enable the listener for the Test_01 database.

Test_01 ENABLE_BROKER;

Note: SELECT is_broker_enabled FROM sys. databases WHERE name = 'test _ 01'

Check whether this listener is enabled (0 is not enabled, 1 is enabled)

2. You must grant the send permission to the Guest user on the QueryNotificationService service in the Test_01 database. The method is as follows. Be case sensitive.

SEND Guest

3. Add the following nodes in web. config:

In the <system. web> node, add

4. Set the cache table when the program starts (set once)

ConStr = System. Configuration. ConfigurationManager. ConnectionStrings [
);

5. Save the cache in the query

SqlConnection conn = new SqlConnection (connstr );
SqlCommand cmd = SqlCommand (= System. Web. Caching. SqlCacheDependency (,); Cache. Insert (, ds, cd );