How to use signalR for getting data from multiple table

Question

User611346789 posted

I need notification from multiple tables and how can i implement this using SignalR??  Receive notification from single table has no problem

Can you please help me to get about this information.??

Answer 1

User-271186128 posted

Hi emrulkayes2103,

I'm not sure what's the mean of "table", could you provide more detail description or code about this issue?

How to use SignalR for getting data from multiple table

If you want to query data from multiple DataTable, you could use Join clause.

I need notification from multiple tables and how can i implement this using SignalR??  Receive notification from single table has no problem

If you can receive notification from multiple table, I suppose it is same with receive notification from a single table.

Best regards,
Dillion

Answer 2

User611346789 posted

Hello,

I have two tables one is deposit and another is Withdraw, Now i want to if any tables changes then how can i receive query notification from SQL server using SignalR

Thanks

Answer 3

User1967761114 posted

Hi emrul kayes,

According to your description, you could use SqlDependency to receive the notification from SQL Server when tables changed and then send notify to client by SignalR.

You could refer to the following link, might it help you.

https://code.msdn.microsoft.com/Broadcast-Real-time-SQL-69dd9fcc

 

If you have any other questions, please feel free to contact me any time.

Best Regards

Even