I am planning a web system in asp.net with c# and while doing the analysis I noticed that it is possible that I needed the data to be updated automatically. Here is the question:
Example: I have a form that is for a waiter, in which he chooses the order of a certain table and this will be saved in the database, because I also have a form that would be like for the kitchen where the orders must be displayed so that get ready.
The doubt is that I want to make them appear immediately or almost, the only thing that comes to mind is to program a query that is executed every few seconds, but since I am referring to a system that will contain multiple forms and tables and a lot of data, I have the doubt if it is the best way to do it. I have been researching but I can't find anything that helps me, is there any technology or method that I can use to solve this problem?
You have taken into account PUSH notifications (facebook style), only instead of placing the notification icon you perform an action, in your case it would be to add the order. There are several options, the most used (or one of the most used) in .net is SignalR . and here an example .
I can't comment, so I'll leave the answer:
You can use PushContentStream in a method of a WebApi application, sending notifications to any client that subscribes to those notifications. The implementation is quick and easy, I have implemented it in several commercial projects. I leave you an example in which they make the call with AJAX, but the logic is the same depending on the technology you want to use... www.c-sharpcorner.com/article/push-notification-in-web-application-using -web-api-and-pushcontentstream/
The example shows a messaging client, but you can return objects and use them depending on your needs.