I wonder if it is possible to let vb.net react on an insert/delete/modify statement in SQL.
This is my situation: I have a planning tool that visualises the planning of an employee. It is possible that several uses use the planning, so I would like to display the changes one user makes on the planning of another user. This means that if user A plans something for employee X, this is immediately visible in the planning form of user B.
To display the planning we use one table, so what I would like is some kind of 'Listener' in VB.NET that reacts on an insert/modify/delete statement in that table, so the appropriate action can be taken.
I know it is possible to search every x seconds for a change in the table (using a 'last modified' timestamp), but that means a lot of queries in the SQL database (= PULL method). I would like a 'PUSH' method.