Stack Overflow
Stack Overflow

Questions tagged [sqldependency]

The SqlDependency object represents a query notification dependency between an application and an instance of SQL Server. An application can create a SqlDependency object and register to receive notifications via the OnChangeEventHandler event handler.

The SqlDependency object represents a query notification dependency between an application and an instance of SQL Server. An application can create a SqlDependency object and register to receive notifications via the OnChangeEventHandler event handler.

MSDN Documentation

454 questions
0
votes
1 answer

How do you properly call "End Conversation" with a multiple result query (SQL Service Broker)?

I am using the Service Broker on SQL Server 2008 R2, and I am registering a stored procedure that has multiple select statements like this: SELECT A.Date ,A.Id FROM dbo.Appointment A SELECT P.Name FROM dbo.Person P When I…
lehn0058
  • 19,977
  • 15
  • 69
  • 109
0
votes
1 answer

Unstable application uses SqlDependency. Several states and errors

I have a windows application using SqlDependency running at separated thread pool, this application represents a log monitor UI get the latest rows added in a specific table in the database and view it in a DataGridView. You can see the application…
Ahmed Negm
  • 865
  • 1
  • 11
  • 30
0
votes
1 answer

SqlDependency using BackgroundWorker

I have a table in a SQL Server database that represents a log file of some actions inserted from a running windows service. Everything is working well. But, I have a Windows application that gets the latest rows that have been inserted in the log…
Ahmed Negm
  • 865
  • 1
  • 11
  • 30
0
votes
1 answer

MemoryCache not added

I have implemented a memorycache following the example on http://www.codeproject.com/Articles/167282/NET-4-0-MemoryCache-with-SqlChangeMonitor I have a problem, the cache isn't added at all. My code: using System.Collections.Generic; using…
CyclingFreak
  • 1,614
  • 2
  • 21
  • 40
0
votes
1 answer

using two sqldependency in one application

my win application have two SqlDependency against two tables on the same database, but only one of them work correctly(the last one). I guessed using SqlDependency.Start(connection, queue Name) and creating two separate queue solve this problem but…
Masoumeh Karvar
  • 791
  • 1
  • 14
  • 32
0
votes
2 answers

Returning data from SqldDependency

I'm trying to write a vb.net application that usesSqlDependency. The dependency will be triggered when data is added to the database. I'm wondering if it's possible to have the dependency return the data/query that triggered it. Currently i have to…
zeocrash
  • 636
  • 2
  • 8
  • 31
0
votes
1 answer

Async call of WCF using Duplex Communication to get Database change

I am implementing and WCF Async service using WsDualHttpBinding binding for duplex communication to get database changes. I have implemented the Service but I dont know how to call it from Client application. Here is the code. The below code is WCF…
Ck.Nitin
  • 161
  • 1
  • 6
0
votes
1 answer

using SqlDependency class to populate ICollectionView with EntityFramework in C#

I want to refresh the ICollectionView object which has some product when a new product is added to database. How can I achieve this in C#, I am using EntityFramework for DAL.
Kishore Kumar
  • 12,675
  • 27
  • 97
  • 154
0
votes
2 answers

Why can't TOP be used with SQLDependency?

I have an application using SQLDependency. I want to display the most recent row inserted into a database table to the user when a new row is inserted. This works as expected when my query is a simple select statement, but given that I want to…
Mansfield
  • 14,445
  • 18
  • 76
  • 112
0
votes
2 answers

SqlCacheDependency in n-Tier Architekture

I read some articles about SqlCacheDependency. I think it is a really cool way for updating caches, but i'm not sure how i can handle this technologie if my application is a n-tier architekture. Is this just useful if my program is a small…
Michael Piendl
  • 2,864
  • 1
  • 27
  • 21
0
votes
1 answer

SqlDependency and Geography SQL Server

I'm trying to get the SqlDependency object to work with geography data, but I haven't found any information about it online. What geography functions work within the query notification system, and is there any way for me to get query notifications…
joe_coolish
  • 7,201
  • 13
  • 64
  • 111
-1
votes
1 answer

Best approach to get notifications from database when table record changing in asp.net core web api

I'm working with asp.net-core 2.2 web api project with angular 7. In this I want to get notifications when a record inserting or updating in specific table. I read many of articles on it with sqldependancy class. But none of them didn't give me any…
mNS
  • 1
  • 1
-1
votes
1 answer

Can I use SQL Triggers to track changes from C# Console App on Database?

I'm a newbie on using SQL Triggers, All I've done that I created an after-update trigger, that whenever I write a SQL update query it shows me the change, but I need to know If I have a console app that runs similar update on the table, would the…
Islam Hamed
  • 11
  • 3
-1
votes
1 answer

Ho do I call a web service on a database change?

There is a business process that happens currently in a totally manual fashion, which seems to me to be a no-brainer to automate. Basically what happens is when a new row is added to a single table in a SQL server, a person then manually makes a…
Sundance
  • 127
  • 1
  • 8
-1
votes
1 answer

Sqldependency error

I want to create a system notification between SQL server Express and Visual studio 2012 (Vb.NET), i looked for this example [Microsoft] (http://msdn.microsoft.com/en-us/library/a52dhwx7%28v=vs.80%29.aspx). I followed all the instructions, but the…
wanted
  • 11
  • 1
1 2 3
…
30
31