I am trying to find a best practice for my situation. I have an MVC C# web application with a SQL Server database. I need to push new records or send updated information to a third party application if data in a number of fields acrossed 4 tables have changed. I have seen in the option of CheckSum in SQL to handle this, or a GUID field. What is the best practice? Should I have a have an table in the middle to tell if the CheskSum value or GUID value changed to call the web service?
Any guidance would be great.