I am integrating SqlCacheDependency to use in my LinqToSQL datacontext.

I am using an extension class for Linq querys found here - http://code.msdn.microsoft.com/linqtosqlcache

I have wired up the code and when I open the page I get this exception - 

&quot;The SQL Server Service Broker for the current database is not enabled, and as a result query notifications are not supported.  Please enable the Service Broker for this database if you wish to use notifications.&quot;

its coming from this event in the global.asax

            protected void Application_Start()
        {
            RegisterRoutes(RouteTable.Routes);
            //In Application Start Event
            System.Data.SqlClient.SqlDependency.Start(new dataContextDataContext().Connection.ConnectionString);

        }

my question is...

1. how do i enable Service Broker in my SQL server 2008 database? I have tried to run this query.. ALTER DATABASE tablename SET ENABLE_BROKER but it never ends and runs for ever, I have to manually stop it.

2. once I have this set in SQL server 2008, will it filter down to my DataContext, or do I need to configure something there too ?

thanks for any help

Truegilly


All Sqlcachedependency Solutions on Gang of Coders

Total of 1 Sqlcachedependency Solutions

Enabling Service Broker in SQL Server 2008