How to refresh the WPF combo-box control data when there are two users on different machines using the same application with same shared database.

See more:

C#

WPF

UI

MVVM

Telerik

Binding

OOP

USER 1 and USER 2 are on the different machines and using the same desktop WPF MVVM application.

Lets say if USER-2 select an option from combo-box and that option is selected on USER-2 machine at the same time on other side USER-1 perform a delete operation of that record, then on USER-2 machine immediately combo box control get refreshed and that selected option in combo-box should show as empty because USER-1 deleted that record.

what should i do to achieve this ?

i have tried to store the database table data in cache and when USER-1 delete the record then cache refresh call made.
USER-2 still needs to logout from the application and the login to see the updated records.
But i want that this functionality should work in real time.
USER-2 no longer needs to logout and then login to the application.

What I have tried:

i have tried to store the database table data in cache and when USER-1 delete the record then cache refresh call made.
USER-2 still needs to logout from the application and the login to see the updated records.
But i want that this functionality should work in real time.
USER-2 no longer needs to logout and then login to the application.