Top "Sqldependency" questions

The SqlDependency object represents a query notification dependency between an application and an instance of SQL Server.

What are the limitations of SqlDependency?

I am using a table as a message queue and "signing up" for updates by using a SqlDependency. Everywhere I …

c# sql-server-2005 sqldependency
I want my database (SQL) to notify or push updates to client application

I was developing this application on VB.net 2010 and SQL 2008. I wanted the clients to be notified for updates on …

sql-server push-notification service-broker sqldependency query-notifications
Service Broker messages start to get hung up after about a day

I have an application that is using the Service Broker is SQL 2008. About once a day the database's performance starts …

sql-server service-broker sqldependency query-notifications
SqlDependency OnChange Not Firing

This is the first time I've ever needed to use an SqlDependency so I am hoping that its a stupid …

c# sql sql-server sqldependency
SqlDependency Reliablity?

My current situation is that I have an application that needs to be notified when new data arrives in a …

c# sql-server sql-server-2008 sqldependency
Detect SQL database changes

Consider this example: INSERT INTO [Table] (column1) SELECT value1 If I were to execute this command in SSMS, in regards …

c# sql listener service-broker sqldependency
Getting data from SqlDependency

I've got a table and a SqlDependency that is waiting for new inserts. OnChange fires as I need, but I …

c# sqldependency
Why is my SqlDependency not firing

I have a database running on MS SQL Server 2005 and an ASP.NET 3.5 web application. The database contains a product …

sql-server sql-server-2005 sqldependency
SQL Dependency in C#

I'm trying to figure out how to use SQL Dependency (C# 4.0) to 'listen' for changes to a database. I've seen …

c# sqldependency
SqlDependency with EntityFramework 6 (async)

I'm using the EF 6 async querying features, such as var list = await cx.Clients.Where(c => c.FirstName.Length &…

c# entity-framework asynchronous sqldependency