460 questions
-1
votes
1
answer
72
views
SqlDependency.Start(connectionString, "SQLDependencyQueue") throwing null reference exception
Below is my code
using System;
using System.Data.SqlClient;
namespace asldf
{
class Program
{
private static string connectionString = "Server=.\\SQLEXPRESS;Database=Sample;User ...
- 1,796
0
votes
0
answers
54
views
SqlDependency: how to work with memory-optimized tables?
I run my C# app using SqlDependency with a query
select productid, productname from dbo.products and it works.
But when I have changed the query to
select productid, productname
from dbo.productsMO
...
- 6,536
1
vote
0
answers
155
views
Connecting SignalR with Oracle Database(Connection with a sample table) in Dot Net Core
I'm trying to connect SignalR with my Oracle database to display real-time data from my table on my website, but I'm having trouble finding any helpful resources online. Could you provide some sample ...
0
votes
1
answer
158
views
SQL Dependency in Web Forms - Detecting changes
I have not used SQL Dependency in practice before, but it is my understanding that DependencyOnChange Event should trigger when I run the SQL update statement below.
To clarify some specifics:
...
- 34.4k
0
votes
1
answer
298
views
Why is the timeout always a multiple of 15 seconds?
We want to wait for a DB table to change in SQL Server 2022 and therefore use SqlDependency in our C# project. That works great but when we specify the timeout in the constructor of the class, it will ...
- 66
1
vote
0
answers
498
views
Using SignalR and SqlDependency with Asp.Net Core 8.0 N-Tier Architecture
I am developing an Asp.Net Core 8.0 API project.
There are 5 layers in my project,
EntityLayer (Class Library)
DataAccessLayer(Class Library)
Business Layer (Class Library)
DtosLayer(Class Library)
...
- 156
2
votes
1
answer
378
views
ASP.NET Core Web Api with Dapper (SignalR-SqlTableDependency): unable to connect to web server https
I use Dapper and N-tier architecture in my ASP.NET Core 8.0 project. My project works with SignalR, but when I add SqlDependency, I get an error
Unable to connect to web server https
Hub side:
...
- 156
1
vote
0
answers
105
views
SqlDependency OnChange does not fire when database changed
I use SignalR to update the interface whenever there is a change in the SQL database. I'm sure I have enabled the Service Broker. The SqlDependency OnChange function still doesn't seem to respond when ...
- 11
2
votes
2
answers
529
views
Using SqlDependency in .NET 7 and WinForms application
In my Winforms application I am trying to use SqlDependency so I created this data access class:
internal class DataAccessLayer
{
private readonly SqlConnection sqlconnection;
public ...
- 832
0
votes
0
answers
33
views
How can I do INSERT to a dependency relation between 3 classes?
I have the mother class Boat and the two subclasses, sailing and motor. If it is a sail type, I have to know how many sails it has, if it is a motor, the power and if it is both a sail and a motor, ...
0
votes
0
answers
54
views
SQL dependency messages doesn't stop
I am a little confused with SQLDependency.
I have a C# WPF application. I need to notify any update in a specific table to other PC's users.
I googled and find SQL Dependency.
https://learn.microsoft....
- 2,487
1
vote
0
answers
223
views
How to make sqlDependency work with left join?
Iam using Sqldependency to monitor my table changes in the database the problem is Sqldependency not work when query contains left join to another table.
After research I find that on of the ...
- 421
0
votes
1
answer
123
views
SQLDependency stops receiving notifications after 1 notification
Good afternoon everyone.
I am working on a project that uses WinForms VB.NET and MSSQL I have a requirement to use SQLDependency to monitor a table for new inserts. I have encountered a problem while ...
0
votes
1
answer
127
views
How to detect Database Changes with SqlDependency and c#
I want to fire a Method each Time a database detected a change. I tried this in a Console Application: (ServiceBroker in Database is active)
using System;
using System.Data;
using System.Data....
1
vote
0
answers
111
views
C# SqlDependency equivalent in PHP 7.4.29 and SQL SERVER 2012
I couldn't find any resources on google and don't know where to start. Is there a PHP equivalent of C# SQLDependency? Where do I get it?
I have followed this answer to enable service broker
ALTER ...
- 111