Hello,
First you need to set up few things
I would suggest you to read some article about this topic.
For inspiration for example:
SignalR Database update notifications in ASP.NET MVC using SQL Dependency[
^]
or
http://venkatbaggu.com/signalr-database-update-notifications-asp-net-mvc-usiing-sql-dependency/[
^]
and you can google many more on this topic.
However if you are new to asp.net, at first you should start with something bit simpler.
But in short it works like this:
1. Set up event on a database
- this event will be fired when something will change
2. using asp.net and signal R (server side) you will deliver this information to client
3. using web-socket/http polling you will get this information to client (usually browser)
and same procedure is when client make change on his side, but from top(browser) to bottom (database)
Also you should think little bit about performance if you want to make a lot of changes in a real time it will consume a lot of memory on database side, because of lot of event will be triggered.