How to manage signalr connection in database

Question

User-1223304583 posted

i am looking for beginner article on signalr connection in sql server database. so if anyone know any url then please post here. thanks

Answer 1

User-271186128 posted

Hi mamoni.kol2017,

How to manage signalr connection in database

You could refer to the following code to connect the database in signalr:

public class Startup
{
    public void Configuration(IAppBuilder app)
    {
    	    // Any connection or hub wire up and configuration should go here
    	    string sqlConnectionString = "Connecton string to your SQL DB";
    		GlobalHost.DependencyResolver.UseSqlServer(sqlConnectionString);
            app.MapSignalR();
    }
}

More details, see:

https://www.asp.net/signalr/overview/performance/scaleout-with-sql-server

https://www.asp.net/signalr/overview/getting-started/real-time-web-applications-with-signalr

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

http://www.venkatbaggu.com/signalr-database-update-notifications-asp-net-mvc-usiing-sql-dependency/

Best regards,
Dillion

Answer 2

User-1223304583 posted

@Zhi i roughly check all your link but none of the link is showing how to manage user connection in database instead of in memory.

see the screen shot please see because those area is not very clear

1) what is message_0 and message_0_id table ?

2) what is payload data in binary format storing in table ?

i got one link which show how to store user connection in db https://www.asp.net/signalr/overview/guide-to-the-api/mapping-users-to-connections

thanks for your help.