CODEWITHSUNDEEP
sqlvb.net
Pakk
Pakk

Reputation: 1339

VB.net SQL Checking

I've been looking for a couple weeks now on what the best way would be to try and come up with a "push-notification" from SQL to VB.net so i don't have to continuesly run Timers and multiple of them on my forms...

Was curious on what you guys would do / have tried and is working for you?

Upvotes: 1

Views: 123

Answers (2)

tgolisch
tgolisch

Reputation: 6734

SignalR is an emerging technology for polling and long-running transactions (for notification, as you are describing it).
This SO question had some good references: How to use SignalR in a webfarm, using Sql server as the backplane

Upvotes: 2

John Tseng
John Tseng

Reputation: 6352

Have you considered SqlDependency (http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldependency.aspx)? Sounds like exactly what you're looking for.

We haven't implemented this in production code. I have a Lazy-ish object that reloads if the value is older than a few minutes old.

Upvotes: 3

Related Questions