Parametrized Interface for datas sharing C#.net

Hello, I started my internship at an IT society, so the subject is : design and development of an application that manages datas sharing between (My Company) systems and external systems. The objective is to create a tool that will allow to parameterize and adapt the interfacing procedures by C#.Net.

I understood: for example Human Ressource application save a new employees in their DB and the second system is Finance Departement, want to use some or all employees column and do their logics based on retrieved datas(salaries,...), if an employee's datas changed in HR database automatically Finaciel System must notified to refresh his database automatically. I was thinking about creating a module of WebServices(SOAP) ,some triggers and a windows service, Am I on the right way or I have a misunderstanding? How can I sort this out ?

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Shashangka Shekhar9y ago
Can use "Query notifications" though a bit old, allow applications to be notified when data has changed.
Have an overview: https://docs.microsoft.com/en-us/sql/relational-databases/native-client/features/working-with-query-notifications

Another way is to use SignalR to capture data change realtime.
Have an overview: https://docs.microsoft.com/en-us/aspnet/signalr/overview/getting-started/tutorial-getting-started-with-signalr-and-mvc