This feature is only available in NCache Enterprise.
Configure SQL Dependency
SQL Dependency can be used in two modes, i.e., the Default mode or Custom mode. In the Default mode, the SQL Dependency creates a default service and queue at run time for the SQL server. In the case of Custom mode, a customer-defined SQL Dependency service and queue will be created and used by NCache. In this case, NCache will connect with the pre-created service and queue with the following naming convention:
You can change the SQL Dependency service and queue name prefix by specifying it against the
<add key="NCacheServer.NCacheSQLNotificationService" value="NCacheSQLService"/>
<add key="NCacheServer.NCacheSQLNotificationQueue" value="NCacheSQLQueue"/>