First post here on Software Engineering, so I hope I don't goof up too much.
I am writing software that integrates with an application written by a company that has a small development team. I have suggested that they add webhooks to their application so that it can be event driven. They have said that they like the idea but it just isn't in the cards for the time being.
Currently I have to continuously call their web service to pick up any new entities that have been created. This works ok, but the more entities that are in the system, the long it takes for me to register that there has been a new one created.
I have decided to try and create these webhooks myself through the use of
SqlDependency. My current plan is to create a windows service that will monitor the database for specific changes and then send the newly created entity's ID to any of the URLs that have been specified in a json file.
My question is can this be done?
What are the drawbacks of using
Are there better ways to achieve this?