signalserver | SignalServer is a web app to accompany QCTools | Computer Vision library

I'm working on this react table sorting when the user clicks on table header it needs to sort the table, sorting is working but the problem is I'm receiving new data every second through SignalR hub and it sets state udata to new data. When a user clicks on table header it sorts the table but again goes back to the new state changed by new data. And cancells the sorted table back to unsorted.

Is there any way I can keep sorted state and still receive data?

I'm new to react any help would be appreciated

I'm trying to read data from the database every second using the following code:

I'm trying to use SqlDependencyEx it accepts the first argument as a connection string, if I use my DB connection string directly it works but I don't want to give it directly instead I want it to grab DefaultConnection using Configuration. but I'm getting this error

A field initializer cannot reference the non-static field, method, or property 'SignalServer.connectionString' (CS0236)

I am writing a package containing a controller that can start an HTTP server and a watchdog to stop the server when a specific HTTP request is given. However, the program will randomly crash because of nil pointer when the watchdog attempts to shutdown the HTTP server. It will crash about twice in 3 attempts. I have simplified the code below. If the code works as normal, it should shutdown the HTTP server after the first request. However, it will properly shutdown only once in three attempts. The other two attempts will end up in nil pointer panic.