I am working with SharePoint 2013 and I have a requirement where I have to perform CRUD operations on multiple external tables (SQL Server) with SharePoint in one List and vice versa. I am able to perform the CRUD operation with one table and one list mapping.
I have performed below operations to achieve this:
Created a view for multiple tables and display the data into a list using External Content Type but unable to perform update, insert and delete operations on it.
Created various stored procedure for CRUD operation and binding them manually to External Content Type and performing the operation.
The 2nd options is working find for me. But it has some limitations and I am looking for OOB solution if any. Could someone suggest me any OOB option for this requirement.
Thanks in advance.