In Sharepoint site, I have a list, it will display data from the table in SQL database.
When user insert, update or delete item in this list, the SQL database will be changed too. The change is one way: from SharePoint to SQL.
I tried the Event Receiver and also tried the External Content type, but each of them have many cons.
So, do we have any other suggestion to automatically update data from SharePoint list into the SQL database when having change in SharePoint list item ?