locked
How to use signalR for getting data from multiple table RRS feed

  • 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.??

    Tuesday, May 23, 2017 5:05 AM

All replies

  • 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

    Wednesday, May 24, 2017 9:02 AM
  • 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

    Sunday, May 28, 2017 4:25 PM
  • 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

    Thursday, June 1, 2017 9:11 AM