Dear All,
I have a problem with sql dependency in my mvc application. the OnChange events not fired when ever data changed in sql server
lets view my code
protected void Application_End()
{
SqlDependency.Stop(ConfigurationManager.ConnectionStrings["IronMountainContext"].ConnectionString);
}
protected void Application_Start()
{
SqlDependency.Start(ConfigurationManager.ConnectionStrings["IronMountainContext"].ConnectionString);
}
The Invoker code
public class NavigationLoader
{
public void PerfromNotification()
{
using (var connection = new SqlConnection(ApplicationSettingsFactory.GetApplicationSettings().ConnectionString))
{
using (SqlCommand command = new SqlCommand(@"SELECT [Id]
,[SiteName]
,[Address]
...
Go to the complete details ...